How to calculate percentage in Tableau for fixed date range with two measures.
I have a data and need to calculate percentage for alternate rows.can some one help on this.attached data file
please submit a twbx workbook with your data so we can see where your attempt has gone wrong
Try the following and see if it plays out with your data. Hope it helps! Thx, Don
IF FIRST()=0 Then 0 ELSE
LOOKUP(SUM([Current Data]),0)/LOOKUP(SUM([Last Data]),-1)
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...