Could you create a mockup of the workbook and attach that?
1 of 1 people found this helpful
So 'Calculation 1' is showing value '1' for Running Total Value less than 50, and value '0' for rest.
If we need the Count of rows where the value is '1' in 'Calculation 1', we just need to SUM the 'Calculation 1'.
Here's a Trick!
1) In Below Image, All the Required fields are there.
2)Create a Calculated Field as Below.
3)Keep 'Solution' in Detail. And Add it to the 'Title'.
(As this calculated field requires few fields in the view, i am adding it to the Title)
4)Now you got the Required Answer in the 'Title'.
5)Remove all fields except Test Name and Uncheck 'Show Header'. Change the Mark type to Polygon.
6)Set the Page to Entire View & it is ready to Display in Dashboard.