Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to write a set analysis expression to calculate total sales where [REGION] is equal to either ‘Africa’, ‘Asia’ or ‘Ireland’
where my total sales amount is a variable called $vSumSales.
Thanks in advance
May be this:
=Sum({<REGION = {'Africa', 'Asia', 'Ireland'}>}Sales)
Hi,
Try this:
=Sum({<REGION = {'Africa', 'Asia', 'Ireland'}>}Sales)
try,
=Sum({<REGION = {'Africa', 'Asia', 'Ireland'}>}Sales)
Thanks guys - they were all the correct answer and I realised what I was doing it wrong.
Moving on from this what if for the same view I now wanted sales broken down by the regions mentioned rather than aggregated ? Ie total sales for Africa, Asia and Ireland each
Create a chart with REGION as dimension and the =Sum({<REGION = {'Africa', 'Asia', 'Ireland'}>}Sales) as expression.
Thanks Sunny - that was glaring me in the face. I think I was trying to take a very difficult route.
No problem
I am glad we were all able to help you here.