I am trying to create a calculated field controlled by a parameter, so that I can selectively display data on a particular chart.
The parameter is simple: it is a string parameter with two listed values - Sales and Margin.
The calculated field based on this parameter is written with a CASE statement as follows:
WHEN 'Sales' THEN [FinalizedSales]
I then display the parameter field selection on the sheet and then add the calculated field to a shelf. The moment the calculated field makes it to the shelf, the application crashes.
Is this an issue because the SSAS cube does the aggregation and the calculated field is attempting to do an aggregation within Tableau?
Retrieving data ...