Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Is it possible to create an addition field (expression) in a pivot table which should be independent of Year dimension But my Sale expression should be dependent on my Year dimension.
I have dragged my Year dimension to the top as usual. Cross table is something i don't want to do, since i will have to change the entire structure.
Output required:
USER | 1-Jan | Feb-15 | Mar-15 | TOTAL | New Value | Difference |
A | 20 | 23 | 12 | 55 | New Expression | New Value - Total |
B | 21 | 32 | 32 | 85 | New Expression | New Value - Total |
C | 22 | 22 | 43 | 87 | New Expression | New Value - Total |
Regards
KC
You can create separate expressions for you year-depended columns using set expressions.
so it will be something like sum({<year = {'1-Jan'}>}sales) for 1 expression, sum(sales) for forth (total), then just expression(..) and the last one expression(..) - sum(sales)
Hi Alexandra,
Sorry i missed to tell that i am using rolling 12 month expression so i don't want to hard code the expression to a particular Year.
Thanks for the help.
Regards
KC
well if this is not a table that you are sending to excel but just show in a dashboadr, you can simply create the second straight table without showing the dimention column and with 3 expressions (total + 2 new) and simple put near the first table
Hi Alexandra,
Even I am doing the same thing, but while sending the reports through Nprinting the tables are getting misplaced and its clear over there.
Regards
KC