cancel
Showing results for
Did you mean:
Helper II

## Matrix visual Problem

Hi, I'm working on a matrix about product prices and their difference with the previous month, so far I managed with no problem to get this matrix:

 Month 1 2 3 4 Customer Origin Brand Product Price Diff Price Diff Price Diff Price Diff A A A Product1 10 0% 10 0% 12 20% 12.6 5% A A Product2 5 1% 6 20% 6 0% 9 50%

In this, the month is the column, and the Price and Diff are the values.

The problem is that my boss wants something a little different,  but I cannot find a way to do it.

Does anyone have any suggestions?

My boss wants to be like this:

 Month Price Diff Customer Origin Brand Product 1 2 3 4 1 2 3 4 A A A Product1 10 10 12 12.6 0% 0% 20% 5% A A Product2 5 6 6 9 1% 20% 0% 50%

1 ACCEPTED SOLUTION
Super User

You could also potentially use a calcuation group for the price, diff calcs, then you should be able to put the calculation items where ever you like in the matrix.

3 REPLIES 3
Super User

You could also potentially use a calcuation group for the price, diff calcs, then you should be able to put the calculation items where ever you like in the matrix.

Helper II

Thank you, that solved my problem!!

Regards,

Super User