Hello All…
I am back with new challenge.
It’s been a while that I posted challenge here. This is very simple challenge.
If you are following tableau new features and using them, you might know how to
solve it. If not, then you might feel this is not possible.
If
you have this kind of challenges or looking for tableau expert help in your
work reach me on Suresh.n2008@gmail.com
Note:
Please download the Data from below link to solve this challenge. If you use
this data, results should match with images posted.
Below I am showing number
of orders by Category, Sub-Category and Segment.
Now I am applying running
sum across table.
Now I want to calculate avg
by Furniture and Segment. For Example, see below
Finally, I want to see
report which looks like below.
Clue: I did not used LOD
calculations. Try with table calculations.