Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have a question - I have a concatenated table with stock levels and sales values. I would like to design a pivot table that will present everything in numbers and values as in the attachment. Do you have an idea? I can handle the division of clients (specified client). "sales other" is the difference between "all / total" and "scpecified client".
Hi,
This is possible. Just get Products as the first dimension, Weeks as the second and then add all your measures. When concatenated correctly on the fields Products and Weeks this will work.
The concatenation of the two fields is important otherwise it will not work. Check if they have the same name/definition.
Jordy
Climber