Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
HirisH_V7
Master
Master

Final Total In Pivot

Hi all,

Here in the Attached Pivot table ,

I required to calucualte Final Performance Line,

It should be , at

Dimensionality=1,

CLP *  Performace

Dimesionality =0,

Total of that above line .


But,when i  select each states it should give relative individual Percentages.

Pivot Fperf.PNG

PFA,

Thanks in advance,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
10 Replies
HirisH_V7
Master
Master
Author

Actually ,

I m not concern about the main total for performance .

final performance line summation required.

HirisH
“Aspire to Inspire before we Expire!”