Help me in getting Totals in Straight Table

[d_prashanthredd]

Hi,

I tried many ways to get the totals (by eliminating duplicates) but haven't succeeded.

Below is the overview of my base data and outputs: Just it is a sample and havemany other fields too.

Also attached the Qlik Sense App.

In my base data, ID (ID-3) and Product (PR-00003) repeated for different campaigns.

Now, my requirement is to calculate the total sockets (Quantity * Sockets) by Campaign and I achieved it. But the issue is with the grant Totals.

My grand total should be 38 but I'm getting it as 40 (considering duplicate values too).

I tried it many ways and at last using only function for calculation.

Note: At any instance (ID + Product) is unique.

[d_prashanthredd]

Thanks for your quick responses..