Hui,
thanks but the thing is to do it without these dummy rows. is there no way to do it?
since it's only a sample table, i think it doesnt really matter how many spaces there are, but thanks)
Hui, thanks, here is the file
http://www.speedyshare.com/files/24599191/sample_pivot.xlsx
so what i want is that a pivot based on the data on sheet "projects" had the layout I have on sheet "Outlook".
as you can see, the pivot I got skips rows with zero values, but I want the layout to be...
Hi all excel experts, I'm a fan of excel and pivot tables but right now I can't solve one problem with keeping the structure of a pivot stable even after data updates.
So the thing is, I have a set of data (pipeline) and some predefined pivot tables. one of them shows data by product groups...