Hello All,
I am fairly new to Tableau and I am facing an issue in my Tableau dashboard. I have created and attached the sample workbook for illustration purposes. The problem is I need to use running count in one of the calculated fields to calculate my savings but I notice that the grand total of the savings is wrong.
The final savings column should show a sum of 65 whereas it shows a sum of 9261 which is the total of savings. Is there a way to solve this issue?
Given above are the sample calculations that I created but the original workbook/calculation requires the usage of running count. Please let me know if this issue can be sorted out. Much appreciated!
Thanks!
Rashini Ashokan
Hi Rashini,
I'm not sure this is helpful for your actual data, but
in this (2nd workbook you attached) case it might be better to use LOD expression instead of Table Calculation if the condition that [RunningCount] = 2 is as is.
