Pivot with Conditional Measure - Total is Blank

[SilviyaK]

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! 

[MatheusC · Accepted solution]

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

[SilviyaK]

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))