9 Replies Latest reply on Mar 1, 2019 6:52 AM by PREETI NAYYAR

# calculating percentage with specific data in denominator

I want to calculate the percentage of my monthly data. The table column that i have to use for denominator has 3 subsets with column names - Yes, No and Maybe.

My denominator has to use the total of Yes and No.

Is there a way i can have a static split up done so that when from my filters i select the percentages of "Yes" from total of Yes and No, i should get that correctly.

Currently, if i unselect "No" the total's value in denominator is only having numbers for "yes" and so its always 100%.

• ###### 1. Re: calculating percentage with specific data in denominator

Hello! so you want that your denominator doesn't change, right?

So you would need the help of a LOD calc so it stays the same, you could write something like this:

Now the filter won't affect the denominator.

Regards

AndresFG

• ###### 2. Re: calculating percentage with specific data in denominator

Hi Preeti,

Do you have some fake data?

Thanks

Deepak

• ###### 3. Re: calculating percentage with specific data in denominator

Thanks Andres! i have never tried this LOD calc.. still learning as i go along. But was thinking something similar... will try this out.

• ###### 4. Re: calculating percentage with specific data in denominator

Row - <field a> <columns - yes, no, maybe>

Row - <field b> ---- count of each column from field a

Column - <Departments>

• ###### 5. Re: calculating percentage with specific data in denominator

Please put something in excel sheet as fake data

• ###### 6. Re: calculating percentage with specific data in denominator

I have attached a fake data and the current way i am calculating it via pivots.

• ###### 7. Re: calculating percentage with specific data in denominator

I will come back to u on this soon

• ###### 8. Re: calculating percentage with specific data in denominator

Hi Preeti,

Like This?

So now if you select from Filter, then you will see actual values.

Thanks

Deepak

If it helps, Pl Mark it Helpful and CORRECT to Close Thread

• ###### 9. Re: calculating percentage with specific data in denominator

This worked... thanks Deepak!