Unpivot one dimension?

  • 20 July 2022
  • 0 replies

I want to show revenue of 1. price discounted items, 2. package discounted items, and 3. all discounted items.

1 and 2 are the only types of discounts we have, so I split the discount revenue (a dimension we have) by pivoting over discount type. However, I want to also add a bar with the total discount. Is there a way to do this? Now I seem to always have to pivot the total discount as well. Can I unpivot one dimension?

This topic has been closed for comments