Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I'm trying to solve the following requirement. We need to create a table that shows some measures on rows and on columns shows the weeks for a selected month plus the cumulated value for that month plus the cumulated value for the whole year. Eg.
Week1 | Week2 | Week3 | Week 4 | Month | Year | |
---|---|---|---|---|---|---|
Actual | ||||||
Budget | ||||||
Act. / Bud. | ||||||
Diff |
My problem is that since I'm using expressions on rows I have to use a Dimension on columns, but as you can see there is a mix between levels (weeks, month, and year).
Any idea on how to solve this with a single table?
Many thanks in advanced.
Pepe
have a look here: Enhanced Pivot Table
--> it is basically the same challenge.
have a look here: Enhanced Pivot Table
--> it is basically the same challenge.
Many thanks Robin,
as you mention It seems to be essentially the same. I'll give it a try.
@Anonymous: Did you find a solution to do it? Can you may share an example app?