on 09-09-2014 8:20 AM
can u share a screenshot of structure view ?
also, what is the formula for the value column?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
what if you use the below formula instead :
=Sum(Count([Leave].[L01 Calendar day]) Where(([v_Completed-Prospect] >0 ForEach([Leave].[L01 Calendar day];[Divisional Office])) And [TSI]=1)ForEach([Leave].[L01 Employee Name]))/Sum([TSI]Where([v_Completed-Holidays]>0)ForEach([Leave].[L01 Employee Name];[Divisional Office]))
whats the formula for second column
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.