Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have below as expression in my chart.
sum( {1} XX_Total)
{1} is used to detach the graph from others.
Now I want to add a condition in the above expression so that the sums up only when there are distinct values based on another field.
Month | Type | XX_total |
Jan 20 | Primary | 50 |
Jan 20 | Secondary | 20 |
Jan 20 | Primary | 60 |
Jan 20 | Secondary | 80 |
Feb 20 | Primary | 5 |
Feb 20 | Secondary | 2 |
Feb 20 | Primary | 6 |
Feb 20 | Secondary | 8 |
It should only do the sum when Type=Primary only.
{1} is required in expression to detach it from other selections.
Can you please suggest what should be my edit expression in this case
Not 100% sure but may be this
sum( {1<Type={'Primary'}>} XX_Total)