Is is possible to have repeating rows during drill down on a pivot table ?
To This - when expanded all the way to Month:
|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.