I am stuck on a calculation where my daily target is showing correct value however monthly target is not correct.
I am using calculation:
IF (FIRST()==0) THEN
WINDOW_sum(max([Test Qty]), 0, IIF(FIRST()==0, LAST(), 0))
Attached is the screen shot.
I want to display monthly target to be same as daily and not sum.
Is this the same as the other ticket...http://community.tableau.com/thread/152279
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...