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
@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 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
