How to display % In Grand Total Column using Dimensionality

[joshibabu_are]

Hi <

I have Organization ,Bucket,Month Year are Dimensions

Count(employee Number ) as Expression

i want to calculate Compliance % in Grand Total(Dimensionality()=0)

Jan 2016 i want to show (96/102)*100=94%

Please find the attached Data Set

[sunny_talwar]

May be this:

If(Dimensionality() = 0, Count({<Bucket = {'On_Time'}>} [employee Number])/Count([employee Number]), Count([employee Number]))

[joshibabu_are]

Hi Sunny,

Thanks for your Time

Iam using  similar expression But iam Getting 98.97% instead of 94% for JAN2016

i want to show distinct count so i used distinct in expression

Please find the attached QVW.

Thanks,

Joshi

[sunny_talwar]

In that case, try this:

if(dimensionality()=0,

Num(Count(DISTINCT{<Bucket={On_Time}>}Employee_Number)/Sum(Aggr(Count(DISTINCT Employee_Number), Org_Hier.ORGANIZATION, Bucket, MonthBucket)),'#,##0.00%')

,count(DISTINCT Employee_Number))

[joshibabu_are]

Hi Sunny ,

its working when its grand Total area.

But i want the same Compliance % as A Calculated Dimension area.

How to achieve same

please find the QVW

Thanks,

Joshi

[sunny_talwar · Accepted solution]

Like this?

=Num(Aggr(Count(DISTINCT{<Bucket={On_Time}>}Employee_Number)/Sum(Aggr(Count(DISTINCT Employee_Number), Org_Hier.ORGANIZATION, Bucket, MonthBucket)), MonthBucket),'#,##0.00%')