hello everyone,
I am trying to create a table where measures are laid out as columns and date related variables are laid out as rows.
the problem is that I can only assign certain variables as rows.
for example, I want to summarize sales related data (columns: sum of sales, avg, total qty, etc) based on the following variables (as rows):
1) YTD sales (2019)
2) Sales all time
3) sales for repeat customers (all time)
4) sales for new customers (all time)
the attached workbook contains a sample of what I am trying to do.
The only thing I can think about is to create various tables and overlay them on top of each other in the dashboard so that it creates the illusion that is only one table
any helps is always appreciated!
I did some stuff on Sheet 1.
Your [repeat customers] calc works already, although I also did it with a FIXED LOD.
And Calculation1 is sales for repeat customers. You can do the same for New. These calcs respond to the level of date you select on Rows.
Become a Viz Whiz on the Forums! Support the Community and master Tableau.