Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I would like to apply set analysis to the attached table, comparing three months, per location. Thanks
Where is Location in your excel file? Is that Branch?
Also, what is meant by comparing three months? Can you provide expected output in excel?
Hi Faisal
do you mean some thing like this,
if not please provide sample result
Manish, Location is Branch !!
And see my original post for the excel. I have attached excel file !!
Comparing 3 months as below...!!
Jul | Aug | Sep | |
BR | --- | --- | --- |
HK | --- | --- | --- |
--- | --- | --- |
Hi Faisal
use branch & month as dimension,
then drag the month to the top of table.
Can you check the attach
Regards
Excuse the previus qvw had an error in the current month formula
Check the new attachment
Hi Faisalaaa
This set analysis will dynamic present the sales for current month and last 2 month - from max selected date
Sum( {$<CalenderYear, CalenderMonth, CalenderQuater, Date = {">=$(=Floor(Addmonths(Monthstart(Max(Date)), -3 )))<=$(=Max(Date))"} >} Sales )
Ex for dimensions
Salespersonal
YearMonth
/Teis
I do not have Year or Quarter nor Date.
Only Months !