topic Re: Pivot Table , Sum and Average in App Development

Pivot Table , Sum and Average

Pdmotta — Thu, 06 Jul 2023 20:50:51 GMT

Pivot Table , Sum and Average

Can we add a Total and an Average summaries in the same Pivot Table ?

Is there an open object that does it ?

Something like

__________client a client b
total _________600 267
avg __________200 800
jan/23 ________100 200
feb/23 ________200 200
mar/23 _______300 400

Thanks.

Re: Pivot Table , Sum and Average

sidhiq91 — Sat, 08 Jul 2023 09:40:24 GMT

@Pdmotta You can try in the straight table. Please see the code that I have used to load the data:

NoConcatenate
Temp:
Load * Inline [
Month, client, Values
Jan,clienta,100
Feb,clienta,200
Mar,clienta,300
Jan,clientb,100
Feb,clientb,200
Mar,clientb,400
];

Exit Script;

To calculate the sum for each client type:

for Client A: Sum({<client={'clienta'}>}Values)

for Client B: Sum({<client={'clientb'}>}Values)

You can set the total function to be as Avg

Re: Pivot Table , Sum and Average

Pdmotta — Mon, 10 Jul 2023 12:46:35 GMT

Thanks sidhiq91, but I need a pivot format with both sum and average.