Set Analysis - Total

[#1]

Hello,

I am trying to calculate the Total Count (ignoring MEDIAGRP) for each TVGRP.  I am expecting value 3 for the first 4 rows and value 4 for remaining rows in the last column.

Can you please help with SET expression.  I tried below, but it did not work.

Count (TOTAL {<MEDIAGRP=>} DISTINCT PANEL_ID)

Thanks so much in advance.

Regards,

Saravanan

[ramoncova06]

switch the MEDIAGRP to TVGRP, that way the total only groups by TVGRP

Count (TOTAL {<TVGRP=>} DISTINCT PANEL_ID)

[#3]

Hi Ramon,

Thanks for the quick reply.  Switching to TVGRP gives the aggregate of ALL TVGRPs (i.e. it populates 5 for all rows in last column).  I need Total of ALL MEDIAGRPs by each TVGRP

Something else you can think of?

Regards,

Saravanan

[#4]

Hi Saravanan,

Can you share a sample .qvw

Thanks,

Harika

[PrashantSangle · Accepted solution]

Hi,

Try

Count (TOTAL<TVGRP> {<MEDIAGRP=>} DISTINCT PANEL_ID)

Regards

[#6]

Thanks Max, it worked

[#7]

Hi Harika, Attaching the file with solved example. Thanks