I am having an issue with ranking by running total table calculation in my data set, will appreciate if anyone knows a workaround to this.
My worksheet is built such as then the user selects the time range, (Last Week, Month to Date, Quarter to Date), the worksheet will do a running total by Fiscal Week of Year (based on product name).
I've replicated the issue on the sample superstore dataset, basically, I want to be able to rank the product name based on top sales (descending).
I tried to rank them by Rank(Running_Sum(Sum([Sales]))) but this doesnt work, same issue with my worksheet that I am working on.
Have attached workbook (2018.2) let me know if that helps.
in that case you can mark it answered.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...