It will depend on how your dimensions and how you build your view. Can you provide a sample workbook so that it will easier to help?
thank you for your answer!
Unfortunately I cannot provide a sample workbook, because the data is confidential .
But I will give some more Details of what I have done so far:
I was given regular Sales data, where I have put years in columns and months in rows (classical crosstab). The measures I have put in there are the Sales data of the years 2017 and 2018.
So far so good. Now I have calculated the difference percentage for each month compared to the previous year, thus the column 2018 now Shows the relative Change compared to 2017.
So everything seems fine now. I have plotted it as a bar Chart. What I want to do now is to create one bar, which represents the average over These months. Since it is a table calc I cannot Change the view without changing the table calc itself, thus I cannot create one bar.
To be a bit more specific:
What I have created in Tableau is the following table:
In this table I created the percentage difference to the previous year 2017, thus not showing any values.
I want to calculate the average of all those percentage numbers. Of Course when I drag out the month-dimension Tableau will Change the table calc and give me a value of the whole difference percentage 2017/2018.
I hope this helps a Little bit :-)
I use superstore data as example for your reference.
below are steps
1st, create the avg and set up table calculation
2nd, keep the first row by using first()=0 as filter
Hope this helps
Book1_v10.2.twbx 2.4 MB
Wow, thank you Zhouyi! :-)
Unbelievable, that you responded so fast! Could you explain to me why this works? Especially the part with First()=0 seems to be the key to the solution, isn't it?
Thank you again!
No worries. I am glad to help, but unfortunately I have to use the sample data to show the steps
The purpose to add First() = 0 is we can't filter the month from the data, so there will be 12 rows in the view, and for display purpose, we just need keep one.
The rest is just about the settings of table calculations, you can follow my steps and see if you stuck somewhere.