H
hedgehog
Is it possible to create groups based on measures in a pivot. My pivot show
now:
Kees - 12
Jan - 5
Hans - 1
I want this:
group 0-5 -> 2 (that's hans and jan)
group 5-10 -> 0
group 10-15 -> 1 (that's kees)
I can create groups on the values on the left of the PT, but it seems
impossible to create groups based on the data values on the right of the PT.
now:
Kees - 12
Jan - 5
Hans - 1
I want this:
group 0-5 -> 2 (that's hans and jan)
group 5-10 -> 0
group 10-15 -> 1 (that's kees)
I can create groups on the values on the left of the PT, but it seems
impossible to create groups based on the data values on the right of the PT.