Dear experts,i have created a parameter named year and 2 calculated fields with Superstore sorces including:SalesCY: if [year]=YEAR([Order Date]) then [Sales] END
SalesLY: if [year]=YEAR([Order Date]) +1 then [Sales] END
Now, i create a new calculated field:
%LY = SalesCY/SalesLY
However, it was unable to show value for %LY, Could anyone give me some advices to comapre SalesCY and SalesLY?
Slight change in your %LY formula.
%LY = sum(SalesCY)/sum(SalesLY)
then change the format of the measure from automatic to percentage
Let me know If this help
Kindly close the thread If possible.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...