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
