Hi D wong,
If i understand correctly, you'd like to have (in the datasource)
both Sales and Sales * Multiplier columns to compare.
It can be done via a Range Join on Date.
Please find the attached as an example.
Sales_Multiplier_v10.5_YF.twbx 34.7 KB
Thanks for the response. I did not see an attachment as an example.
So my question is more on the next step. Basically, I know how to get to this:
Sales * Multiplier
a x 1/1/2010 b y 3/1/2011
My issue is the following:
I need the data to display only the top 10 "sales * multiplier" region as of the latest date available in a bar graph.
Right now, for the bar chart, I have to manually filter to the latest date, manually click to sort by sales * multiplier, and then filter by the top 5 results. How can I automate this process?
Hi D wong,
You've written in reply:
... I did not see an attachment as an example.
Please open this thread in a browser (not in an email client)
and look at the lower left corner of my previous reply.
You could see the Clip with the Filename of the workbook.
As for your last question, you may want to use a RANK() Table Calculation.
Please find the attached (in this thread) with the Top N view added.