Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to remove the column of one dimension in pivot table

Hi all,

I have a pivot table and it has two dimensions date and used. How can i move the column of used? I dont want it show in my report....

Thanks

Jelly

Capture.PNG

11 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

If you don't want in the chart then you can simply remove that dimension in the chart, if you are doing any calculations based on that used you can manage it with Aggr().  If you come up with sample data and expected output then it would be easier to give solution.

Regards,

Jagan.

magnuslander
Partner - Contributor II
Partner - Contributor II

Did you ever find a solution to this? I'm working with the same problem.