Hi Dear comunity
I need made a Pivot table with a range dimension. This is the original datatable
The desired pivot table is:
Check out this thread/answer:
Just use some nested if statements to set it up however you want.
If(Age<=15,'From 0 to 15',if(Age<=30,'From 16 to 30','Up to 31')) would work for your dimension. The expression would just be sum(value)
Retrieving data ...