topic Re: Pivot with Conditional Measure - Total is Blank in App Development

Pivot with Conditional Measure - Total is Blank

SilviyaK — Mon, 02 Dec 2024 15:29:53 GMT

Hi,

Can I please get come help with the below:

I have the following in a simple table:

From 'Totals Function' I can select the the totals function to be a sum and it shows me the total (10).

If I do exactly the same in a pivot though, this happens:

How can I make it show the total (10) in a pivot table? There is no totals function or anything equivalent.

This is just a sample, the original data needs to exist in a pivot in order to fulfil the rest of the requirements for the view.

Thanks!

Re: Pivot with Conditional Measure - Total is Blank

MatheusC — Mon, 02 Dec 2024 18:35:03 GMT

Hi, @SilviyaK
Try putting the values resulting from your condition inside a sum(),

Sum(
if(_Country='Belgium',2,
if(_Country='France',5,
if(_Country='Germany',3))))

*****************************************************************************

Below is my example in the pick() function

sum(pick(match(_Country,'Belgium','France','Germany'),2,5,3))

*****************************************************************************

If possible too, you could be taking the condition to the script.

- Regards, Matheus

Re: Pivot with Conditional Measure - Total is Blank

SilviyaK — Tue, 03 Dec 2024 07:27:10 GMT

Thanks! I also found that it works this way too:

Sum(Aggr(
if(_Country='Belgium',2,
if(_Country='France',5,
if(_Country='Germany',3))), _Country))