Skip to main content
Topics#Tableau Desktop & Web AuthoringDomanda di Kalin Stoimenov
Kalin Stoimenov (FirstStudent) ha fatto una domanda in #Tableau Desktop & Web Authoring
2 nov 2017, 04:06

Rolling 12 - Problem

Hi All,

 

I am trying to develop a report that will show JUST the Rolling 12 Average Amount  for the last month and also once I get this ,  I would like to do the same for  the R12 Amount for the prior month and the prior year.

 

I was able to create calculation to show the  Amount from the last  month,   but I can't get to work the R12 Amount Calculation.

 

Rolling 12 - Problem

 

I hope this make sense . Please also see the attached report.

 

Appreciate in advance !!!

 

Thank you!

NewRecords.twbx
9 risposte
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    2 nov 2017, 06:47

    Hi Kalen,

     

    Ok, you are trying to use table calculation without include the calc dimension (Month) ... you can do the following:

     

    1- drag the date into detail mark as follow:

     

    Hi Kalen, Ok, you are trying to use table calculation without include the calc dimension (Month) ...

     

    2- Change your table calculation to be as follow

     

    pastedImage_1.png

     

    3- Add your table calculation to size mark to get the last month calculated value as follow:

     

    pastedImage_2.png

     

    Note:

    If you found this the useful, please mark it as the correct answer or helpful post

     

    Best Regards

Scrivi una risposta...
0/9000