I have requirement like i have 3 tables Yearly table,Monthly, Original Transaction Table and have 5 global filters(Year,Month,Week,Country,Region).
If user passes year selection value then we need to display measure from yearly table
If user passes Month selection value then we need to display measure from Monthly table
If user passes other than (Year/Month) like country, week etc selection value then we need to display measure from Original Transaction table.
could you guys please help me how to create single calculated field to display data in one KPI based on user selections.
I think we'll need to see some sample data or a packaged workbook in order to be of much assistance here. Can you share one of those?
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...