Forum Discussion
Help required in Switch statement
Since the first statement for "Total Sales" consists of the dates rest of the statement is not executed. If I remove the first statement which is "Total Sales" rest of the statement is executed. Wha...
Thanks but you have passed wrong date here hence it was working...
Sample[Date] >= date(2019,9,1)
&& Sample[Date] <= date(2019,9,30), "SampleOlderThanThisMonth",
It should have date(1900,1,1)...
As a quick fix I renamed the "Subtotal" to "Total Sales" 🙂
Only concern is I am not able to bring it to the top though I select Top in the subtotal settings.