I have the following pivot table in Q-View. Sample data provided below.
These are my Dimensions = Product and Month (based on Master Calendar)
I created 6 expressions to generate totals for a given month. I need to create Quarters, YEAR TO DATE and Prior Year for the corresponding expressions in the same pivot table. What is the best approach?
Thanks for responding. After looking into your suggestion the Quarter 1, Quarter 2... expressions will be a record under the established ones (e.g. Mazda,Rate-1, Rate-2) rather than columns alongside Month. How do I get an expression to be columns?