Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is is possible to have repeating rows during drill down on a pivot table ?
Example:
From this:
Year | Measure1 |
Quarter | |
Month | |
To This - when expanded all the way to Month:
Measure Total | |
2017 2017-01 Jan | 220 |
2017 2017-02 Feb | 330 |
I can't use a tabular table since I need to pivot the data. Or if not possible, is there a setting to allow the pivot to export in this format ?
Another question. Is it possible to remove from the pivot table a dimension or measure in run time.? The only option I could find is to use remote in edit mode and then applying the changes.
Thanks
Sure you can,
instead of having as dimensions:
1) Year
2) Quarter
3) Month
It will become:
1) Year
2) Year&'-'&Quarter
3) Year&'-'&Quarter&'-'&Month