Forum Discussion

asl10's avatar
asl10
Helper I
9 years ago

Compare Feature Sales with Previous Year Feature Sales

Hi, I would like to compare sales of reserved bookings (Hotel) for 2017 with reserved booking sales for the same period last year?   E.g. Based on Input Date of users 2016 i can see the figures fo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi asl10

 

I forgot to mention that the SlicerTable should not be linked to anyother table it should be a stand alone one.

 

Cheers

 

CheenuSing

asl10's avatar
asl10
Helper I
9 years ago

Hi Anonymous,

 

Thank you for your input. Very innovative solution and almost there as with my real data the past value was showing all the total and not the specific total between the specific dates. Furthermore, this solution is limited for comparissons and decision making as i do not have the months and cannot filter accordingly to any other data. Currently i have this solution (see below pics) which the years are manually entered as a filter in the 2 graphs. I'm after the same thing but in the same graph, like when we have YTD and Last Year YTD side by side.

 

I after somethin like this:

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi asl10

     

    Please provide sample of actual data and the final output you desire. I am sure we can find the solution.

     

    The data you can share using one drive.

     

    Cheers

     

    CheenuSing

  • asl10's avatar
    asl10
    Helper I
    9 years ago

    Dear Anonymous,

     

    The actual data are the same principal as my sample data. Its the same with just more dates and revenue.

     

    The final output im trying to achieve is like the last picture. To have the revenue side-by-side on a single graph based on the input date asOf today and input date asOf today Last Year.