conditional display column in straight table.

[ronaldwang]

  I have a table where I show the sum of sales of each month using formula like sum({<month={Oct},year={2017}>}amount) as Oct17 Sale, sum({<month={Nov},year={2017}>}amount) as Nov17 Sale. In the condition column how do  I set the condition so that Oct17 Sale will be displayed only when Oct & 2017 is selected? thanks

[Anil_Babu_Samineni]

If you make condition like Sum(amount) and list boxes are Month & Year (Go ahead and filter) on Oct & 2017. What are you getting?

[prma7799]

simply write if(((MonthName ='Oct')),1,0) in Condition box

[ronaldwang]

it will still display

[ronaldwang]

but user can select Oct,Nov, Dec etc, then the month name will not be uique

[prma7799]

How many expressions do you have in your chart?

[Anil_Babu_Samineni]

does it mean, You can set it up as below

If(GetFieldSelections(Month) > 0 and GetFieldSelections(Year) > 0, 1, 0)

[tresesco · Accepted solution]

Try like:

=Max(Index(Month, 'Oct'))

With this, even if you select multiple months the expressions would be visible for respective months.