I'm just getting started in Tableau, probably a basic question. I need to create a table with four measure columns for just one dimension.
Market, Current Month Volume, % Chg from Previous Month, % Chg from Previous Quarter, % Chg from Previous Year
For Current Month Volume I'd like..
Sum(Volume) where month = max(month)
For %chg from previous month I want to essentially say..
Sum(Volume) where month = max(month) / Sum(Volume) where month = max(month) - 1 (you get the idea, usually use AddMonths - 1)
I'm still trying to do this, but given a deadline thought I'd reach out.. thanks.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...