I have column groupings by month in a pivot table.
Lets say Jan, Feb, Mar all has columns A, B, C, D, E. and columns A and C are static data and never change
but B, D, E change by month
I would like to keep columns A, C as static columns and only display them once in the table together and rest of the columns for every month.
Can you guys suggest me some ideas to do this. I wrote a macro to hide the columns but that hides or displays columns for all months and not display them just once.
I even tried breaking the table into two and only show the two static columns in one and others in the other one but the tables together don't render correctly.
Any ideas are welcome
As I saw in an other post, I am trying to have another inline dimension on top of the month to say if it is static or repeat by month.
Do you think that will work with dynamic expressions and dynamic dimensions???
I mean if my months are driven by the data???
Still not quite clear...
Maybe what you need is to use static columns A and C as dimensions, probably as calculated dimensions. One more dimension is month. Three expressions, B, D and E.