Skip to main content
Topics#Tableau Desktop & Web AuthoringFrage von Yaron Grosberg
Yaron Grosberg fragte in #Tableau Desktop & Web Authoring
15. März 2022, 15:19

Help with an LOD calcination

Hi all, 

 

I am having issues with a calculation. 

In Sheet 1 - I have a total of 45,512,00

In Sheet 2 - I am trying to get the same number without building the grid. 

 

The calculation is : Amount * capacity *Count(Team Alpha schedule)  

 

Thanks! 

Yaron 

Try.twbx
2 Antworten
  1. DIEGO FERNANDO MARTINEZ RODRIGUEZ (Modux)
    15. März 2022, 16:05

    @Yaron Grosberg​ 

    Hi, in this case you can create a calc like:

    {FIXED [Tier Name],[Price Code]:[Full Season Revenue]}

    Also, you would need to add the filter to context:

    @Yaron Grosberg​ Hi, in this case you can create a calc like:{FIXED [Tier Name],[Price Code]:[Full Season Revenue]}Also, you would need to add the filter to context:That way the dimension filter willThat way the dimension filter will be calculated before the fixed calc. (Pill will turn white-gray)

     

    Attached you will find the workbook.

     

    If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

     

    Regards,

     

    Diego Martinez

    Tableau Visionary and Forums Ambassador

    Try (1).twbx
Antwort schreiben...
0/9000