If dimensions is x, then Total

[canmarroig]

Hi, i've to map some dimension:

color RED, BLACK, YELLOW

then create a pivot table where I compare

red vs all colors

black vs all colors

yellow vs all colors

My final result should be

with a final column to be shown only on color.

Can You help me?

[petter]

Could you provide a QVW with some sample data already loaded - then it is much easier to get help for you.