Showing expression as dimension in pivot table

[#1]

Hi All,

I have to create a report which contain strategic code,KPI as dimension.And my expressions are actual,previous year, and annual budget plan .

My problem is that I dont have strategic code and KPI fields in my source table.

Kindly find the below screen shot for your understanding

[sunny_talwar]

Is that information, I mean strategic code and KPI field coming in from other source? or are they static and can be created in the script using Inline table?

Would you be able to share some raw data of what you have and what is your intended solution?

[#3]

Hi Sunny,

Thanks for your reply,yes strategic code and KPI are static,the screen shot which I posted is not my source file .

the source file is different.Turnover,gross margin etc need to be calculated from that source file .

kindly let me know any more information you want from my side

[Gysbert_Wassenaar]

Post a small qlikview document that demonstrates the problem and an excel file with source data and your calculations.