Creating addition Expression in Pivot table independent of Year Dimension

[jyothish8807]

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

[#2]

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)

[jyothish8807]

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

[#4]

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

[jyothish8807]

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