Please see attached 10.2 workbook; lowest versioning that we can go for exporting version as (hopefully opens for you). Please follow along:
Changed [Curr Week Sales] to a Fixed LOD:
Did the same thing for [Previ Week Sales]:
Changed [Sales Diff] to the following (needed to use SUM and ROUND):
Then selected Sub-Category pill and clicked on Sort:
A new dialog box opens. Use the drop-down and selected sort on [Sales Diff]:
Sort order is now High-to-Low based on Sales Difference for most current week:
Sort by Calculated Field_v10.2.twbx 406.6 KB
Hi Don Wise,
your idea Calculating diff is working.
But there is a concern with Latest Week parameter value. When data is updated, a new week added but parameter values is not refreshed to latest data.
How to we set dynamically refresh parameter to latest date from the date filed. ? or select max/latest date from date column/filed ? so that latest week value can be referenced in calculations.
Sort by Calculated Field_v10.2.twbx 447.4 KB
Currently, as far as I know, there's no ability to 'dynamically' update your parameter control to 'Today' or to use the TODAY() function for latest date in the parameter settings. Parameters are static. A workaround would be to Edit your Parameter and set it for a date far into the future so that as new data arrives, it should recognize and display the updated data accordingly. Hope that helps.
I think the original question was answered here as well, so please close the thread by marking as correct. Thx! Don
Is there any way instead of opening workbook every week ? I want to automate the updating latest date in workbook, Once workbook is published.