
1. Re: Calculation with two parameters
Joe Oppelt Sep 20, 2019 3:01 PM (in response to Julianne Jochym)I added a sheet to your workbook. On sheet 3 I made a crosstab of your data.
Now, what do you want to see when choices are made in the parameters.
(One of the problems I see on the forum is people trying to get a viz to do what they want to do without really understanding what the underlying data is doing first. So I like to start with a crosstab. Get the data to behave there, and then incorporate it into the actual viz.)
Calculation Focus A.twbx 33.6 KB


2. Re: Calculation with two parameters
Julianne Jochym Sep 23, 2019 9:31 AM (in response to Joe Oppelt)Thanks Joe,
What I am trying to do is create a calculation so that based on which "Calculation Parameter" and which "Club Parameter" you choose, only that Calculation for that Club will show up.
I created a new crosstab of the four data fields I am trying to see. In this case, I would like to create a calculated field so that if I selected Club Parameter "A" and Calculation Parameter "Total Revenue", I want to see the sum of the green boxed information below:

Calculation Focus A.twbx 40.9 KB


3. Re: Calculation with two parameters
Joe Oppelt Sep 24, 2019 8:05 AM (in response to Julianne Jochym)In the attached I made a copy of your crosstab.
The param for the Club could simply be a filter on [Club], but I used the param to demonstrate how you can use the param in this way. I made a filter, [Pick the Club Value] and put that on the filter shelf and selected for TRUE.
For the Calculation param, I made [Pick the Calculation to show]. I display that, rather than Measure Values.
The two calcs working together on your sheet will give you what you are looking for.

Calculation Focus B.twbx 43.9 KB


4. Re: Calculation with two parameters
Julianne Jochym Sep 24, 2019 10:52 AM (in response to Joe Oppelt)Thanks again Joe,
Unfortunately what I am trying to do is a bit more tricky than applying a filter as I need to be able to show all Club data while also having a dedicated color for the Club I select in the same worksheet.
On the original Revenue worksheet, I am able to do this by creating the "Revenue Focus" measure; however, I'm not able to switch the calculation to see something such as # of deals. On the Parameter Calculation worksheet I'm able to switch between different calculations; however, I'm not able to use dedicated colors (i.e. Like Clubs will be dark gray, selected Club will be a specific color I choose).
The image below is the calculation I tried to create, but it doesn't work. I'm hoping to have it so that based on which calculation I choose via the Calculation Parameter (the red box below), it will return that calculation for only the Club I choose via the Club Parameter (the green box below).
Thanks again!

5. Re: Calculation with two parameters
Joe Oppelt Sep 24, 2019 1:16 PM (in response to Julianne Jochym)If I understand what you're saying, see attached:

Calculation Focus C.twbx 53.9 KB
