Total and filters

[#1]

Hello!

that is my table:

I need to obtain the total I've put in field "R_T" as follows:

If(COD=9937199,Sum({<COD={9937199},TIME=>}AD)-vSumT9937302,

if(COD=9937072,Sum({<COD={9937072},TIME=>}IN),Sum({<TIME=>}AD)))

And R:

If(COD=9937199,Sum({<COD={9937199}>}AD)-vSum9937302,

if(COD=9937072,sum(IN),sum(AD)))

My variable:

vSumT9937302=Sum({<COD={9937302},TIME=>}AD)

vSum9937302=Sum({<COD={9937302}>}AD)

In R gets all filters and R_T not take the filter TIME because I want the total always displayed.

The problem is that when a COD  does not have data in TIME, in this case,  COD 9937072 does not have data in TIME "3"  so when I filter TIME 3 does not give the total correctly.

How I can fix that? I want to see total every time

I attached file. Thanks!!

[pokassov · Accepted solution]

Hi!

I fixed it. See expression R_T2

[#3]

Hi! thanks!

And if the COD of the variable has the same situation:

What is the code for the variable vSumT9937302 to show always the total?
Thank you!

[pokassov]

As I see we exclude TIME in the Set Analysis. So vSumT9937302 always ignores selection on TIME.

Or I didn't get your question...

[#5]

You're right! Everything it's ok.

Thank you very much!