5 Replies Latest reply: Feb 15, 2017 7:04 AM by Sunny Talwar

# How to display % In Grand Total Column using Dimensionality

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

• ###### Re: How to display % In Grand Total Column using Dimensionality

May be this:

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

• ###### Re: How to display % In Grand Total Column using Dimensionality

Hi Sunny,

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

Thanks,

Joshi

• ###### Re: How to display % In Grand Total Column using Dimensionality

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))

• ###### Re: How to display % In Grand Total Column using Dimensionality

Hi Sunny ,

its working when its grand Total area.

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

How to achieve same

Thanks,

Joshi

• ###### Re: How to display % In Grand Total Column using Dimensionality

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%')