Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've been asked to create this table:
2015/16 | 2016/17 | May-15 | May-16 | |||||||
Indicator | Q 1 | Q 2 | Q 3 | Q 4 | Q 1 | Q 2 | Q 3 | Q 4 | ||
Sales |
|
|
|
|
|
|
|
|
|
|
Customers |
|
|
|
|
|
|
|
|
|
|
I've managed to create 2 separate pivot tables, one with year and quarter, and the other with month (with some calculations to only show the most recent month, and the same month for the previous year) but I'm not sure how I can have them both in the same object.
Any help would be appreciated.
Hi Charlotte!
I suggest you change your load script creating new fields to comply your need (that is information of different aggregation in the same object). Is it possible to attach an QVW with your context?
Best regards,
Marcello
Thanks for your reply. When you say to create new fields, what do you mean? I already have the dimensions I need (year / quarter / month) - I just wondered if there was any way of putting them side by side like the table above.