Set Analysis

[dunnalahk123]

Hi,

I am trying write on expression in set analysis.

=Sum({$<Distinct [ASDP Name] =>}[CSNUM])

=(AGGR(SUM(DISTINCT [CSDEN]),[ASDP Name]))

basically i need For Distinct ASDP Name what is the sum of NUmerator.

Can some one help me here.

Best Regards,

HK

[dunnalahk123]

Hi Sehrawat,

Thank You So much, we are almost there.

One thing in my saved attachment which i just upload again at original post  i have selected one ASDP name which is there in both EMEAHQ and SPAIN  .For EMEAHQ it shows 0 as NUM and 1 as DEN which is correct but for SPAIN it shows both num and Den as 0. which it should not be.

For SPAIN as well it should show same number which it shows for EMEAHQ as 0 and 1.

If possible can we tweak this.

But thanks a lot for all your help. Really Appreciated.  🙂 🙂

[neelamsaroha157]

You can add 'Subregion' in the aggr with '[ASDP Name]'.

And you are welcome

[neelamsaroha157 · Accepted solution]

Let me know if it gives the desired output. I tried on my end and it seems to work.

[dunnalahk123]

Hi neelamsaroha1575

Thank You so Much for all your time. it works now. 🙂

Have a nice day 🙂