I want to make a Pivot on a few Calculation that I turned into Dimensions (TheCalculations are an IF THEN ELSE Construction returning 1 or 0). Now when I go to the Datasource and select thouse Columns i don't get the Option Pivot by presing the Drop Down Arrow. How I need to convert thouse Columns so I can Pivot them?
Unfortunately, the Pivot option cannot be used in calculated fields therefore you will have to restructure the data prior to create the flags mentioned above. If you require further help attach a sample dataset.