Find my approach as reference below and stored in attached workbook version 10.3 located in the original thread.
1. D1. Count Order ID: COUNTD([Order ID])
2. D2. Profit avg:
3. D3. Delta count: ZN(COUNTD([Order ID])) - LOOKUP(ZN(COUNTD([Order ID])), -1)
4. D4. Delta avg Profit: ZN(AVG([Profit])) - LOOKUP(ZN(AVG([Profit])), -1)
5. D5. Delta Profit: ZN(SUM([Profit])) - LOOKUP(ZN(SUM([Profit])), -1)
6. Drag required objects to the indicated locations
Difference_nalmai_10.3.twbx 1.2 MB
You've asked me to help with this question. So my answer below.
Norbert had come first, and his solution is clean and simple. Mine is not.
In fact, it's a dirty and complicated trick using Custom Grand Totals.
I post it just to show (up :) there might be another way to get to the result.
For the logic behind Custom Totals, please refer to
the seminal blog article by Jonathan Drummey :
Please find the attached.
Difference_v10.3_YF.twbx 1.2 MB
1 of 1 people found this helpful
Hi Yuriy Fal ,
Thanks for that:)
As always there are "more roads to Rome" in Tableau. Starting "plain & simple" to "going completely wild";)
I will store your approach in my "treasure room"...
Have a nice one
Thanks you so much guys for the answer. Can we mark multiple answers correct?
Happy holidays and new year!!
Andrew, you're welcome.
Nope, just pick one (FIFO imho).