Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Post an example...
I paste the image of table which I want pivot.
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).
Have you solved your task?