This content has been marked as final.
Show 1 reply

1. Re: Calculations using only certain Dimension values
swaroop.gantela Jul 26, 2018 7:57 PM (in response to Suzanne Parr)Suzanne,
I think you can try Level of Detail Calculations to obtain this:
Numerator:
{ FIXED [Brokerage Firm Rollup],[Effective Date (Years)],[Effective Date (Quarters)]:
COUNTD(IF [Stage]="Closed Won" THEN [Account Name (copy)] END)}
Denominator:
{ FIXED [Brokerage Firm Rollup],[Effective Date (Years)],[Effective Date (Quarters)]:
COUNTD(IF [Stage]<>"Closed Withdrawn" THEN [Account Name (copy)] END)}
Note: I added the two date calculations using Custom Dates:
Please see workbook v10.3 attached in the Forum Thread.

276932close.twbx 1.2 MB
