Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Modify the total formula in one dimension in a pivot table

Hi,

Is it possible to change this formula? For example: if i have two columns and the total value is not the sum, average, or other operation, but another expresion. If i create this expresion, it appears pivot, and i don't want it.

Other idea is put an expression outside the dimensions pivoted. Is it posible?

Thanks for your help!!

Alberto


3 Replies
jolivares
Specialist
Specialist

Post an example...

Not applicable
Author

I paste the image of table which I want pivot.Captura.PNG

In this table, i have 3 dimension Day, Type_Day (SBDO, DOGO, LABL) and Service (T1, T2 and T3). Two diensions Ti and V. The column total is the sum of Ti (of T1) * V (of T1) + Ti (of T2) * V (of T2) + Ti (of T3) * V (of T3) and all divided by V(of T1)*V(of T2)*(of T3). I have get the same changing the load and fiels in script with a simple table but I want use the pivot table (it's more quick).

stantrolav
Partner - Creator II
Partner - Creator II

Have you solved your task?