1 of 1 people found this helpful
see the attached
the formulas you want to use are and If statement that compares the order date to a date you want total sales
in the attached I used the max date in the filter and the prior year
and it returns this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
In addition to directions provided by Jim Dehner find my approach as reference below and stored in attached workbook version 10.3 located in the original thread
1. D1. Display: DATEDIFF('year',[date],today())=1 and [date]<(dateadd('year',-1,today())) or DATEDIFF('year',[date],today())=0 and date<today()
2. Drag required objects to the indicated location and filter D1. Display on True
3. Set SUM(value) > Right Click > Textmenu > Quick Table Calculation > Difference
Thank you very much Jim
I am unable to understand your logic of using Windows_max function, Can you please help to explain more on that.
Also main purpose is I am trying to get it using Fixed LoD Vs Dimension filter, Where Fixed is being used to get the previous year data and Dimension filter is to get the current year because I need to get the top 20 of current year along with previous year (Apologize for not including this in original question).
Thanks for your patience.
Thanks Nobert for response.
I have done something like the way you have shown, but here what I am trying to do is get the data of 2017 using the Fixed LoD along with the filter in place and I am unable to get it, As I have also requirement to get the top 20 customers for current year.
Find my approach on TOP N below and stored in attache workbook version 10.3 located in the original thread
1. M1. Rank: rank(sum([Sales]))
2. P1. Top N
2. M2. Display: [M1. Rank]<=[Top N]
3. Drag required objects to the indicated locations and set M1. Rank to Discrete & Compute Using > Customer Name
and display parameter control