I am trying to find Max, Min and Average value within last 12 Months.
Let say in below example
Sub Product , Product, BU, Abc, Xyz are my different dimensions at different granularity
if I have all of the above dimensions as filters, I should be able to get MAX, MIN, AVG $$ value in the Last 12 Months.
You Can try using this logic:
IF LOOKUP(SUM([$$]),-12)>0 THEN
WINDOW_AVG(SUM([$$]), -12, -1)
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...