1 of 1 people found this helpful
The best way I have found is to create a dashboard out of the first sheet and create a second sheet with only the calculation of 36585/680. Then, you can use the float option to drag it to where you want to show the result. It's not as convenient as showing it directly on the same sheet but at least it works.
1. Create a new sheet and a new calculation:
SUM(IF [test]="Hold" THEN [search] ELSE 0 END)/SUM(IF [test]="Err" THEN [search] ELSE 0 END)
2. Drag the Measure names field on the Rows section.
3.Filter the brand field ton only show 'b'
4. Filter the Measure names to only show 'search'
5. Edit the alias of the line to have it show Total or Ratio, or whatever you want to name that calculation.
6. Create a new dashboard and add the two sheets
7. Make the second sheet float and drag it to place it where you want to display it.
As for your second question, the same solution can be applied to show the exact total (create a calculation on a separate sheet and add it to the dashboard)
I am getting nulls and zero on calculation.
Can you please help by updating the workbook with your inputs.
Any help on doing such computation. Please update the wb with the possible solution
I have been able to use the solution given be edgar.
Please find attached image. Problem is I have 2 dropdowns and if no data is available in either the rows go blank and there is a gap between the rows and total or the rows and calculation overlaps. As suggested the total is in a sheet and is floating on the dashboard. Please suggest how to show the rows with NULL or NA even if data is not available. This way the gap will not be visible.
Untitled.png 16.1 KB
The attached workbook utilizes table calculations to derive the Numerator and Denominator and extend these over the rows of data to achieve the 36585/680 at a per row level.
IF INDEX()=1 THEN WINDOW_SUM(SUM([search]),0,5-INDEX() )
If INDEX() =6 THEN WINDOW_SUM(SUM([search]),0,10-INDEX())
Then simply using these calculated fields in a new calculated field that creates the fraction.
I do not know of a possible way to make the result appear on the Total line however.
sample_new_2.twbx.zip 18.1 KB
Thanks a lot Patrick...just the perfect solution to the problem.
Can any please help with solution to display the calculated value in the total line ?