Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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?