
1. Re: calculating percentage with specific data in denominator
Andres Garcia Feb 13, 2019 3:16 PM (in response to PREETI NAYYAR)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:
COUNT([answer]/ SUM( { COUNT([Answer]) } )
Now the filter won't affect the denominator.
Regards
AndresFG

2. Re: calculating percentage with specific data in denominator
Deepak Rai Feb 13, 2019 3:47 PM (in response to PREETI NAYYAR)Hi Preeti,
Do you have some fake data?
Thanks
Deepak

3. Re: calculating percentage with specific data in denominator
PREETI NAYYAR Feb 14, 2019 11:53 AM (in response to Andres Garcia)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
PREETI NAYYAR Feb 14, 2019 11:55 AM (in response to Deepak Rai)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
Deepak Rai Feb 14, 2019 12:38 PM (in response to PREETI NAYYAR)Please put something in excel sheet as fake data

6. Re: calculating percentage with specific data in denominator
PREETI NAYYAR Feb 14, 2019 1:38 PM (in response to Deepak Rai)I have attached a fake data and the current way i am calculating it via pivots.

Pivot calc.xlsx 12.9 KB


7. Re: calculating percentage with specific data in denominator
Deepak Rai Feb 14, 2019 1:39 PM (in response to PREETI NAYYAR)I will come back to u on this soon

8. Re: calculating percentage with specific data in denominator
Deepak Rai Feb 14, 2019 5:27 PM (in response to PREETI NAYYAR)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

LOD1_v10.3.twbx 21.9 KB


9. Re: calculating percentage with specific data in denominator
PREETI NAYYAR Mar 1, 2019 6:52 AM (in response to Deepak Rai)This worked... thanks Deepak!