Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Dear comunity
I need made a Pivot table with a range dimension. This is the original datatable
Age | Class | SubClass | Value |
---|---|---|---|
10 | A | A1 | 100 |
20 | A | A2 | 200 |
30 | C | C2 | 300 |
60 | D | D1 | 400 |
90 | F | F2 | 500 |
The desired pivot table is:
Range (Age) | Value (Sum (Value)) |
---|---|
From 0 to 15 | 100 |
From 16 to 30 | 500 |
Up to 31 | 900 |
Thanks !!
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)