How to disable the selection

[#1]

Hello Friends,

I'm facing one issue in QV can you any one help me to resolve, Issue description has  below

I have Distributor, Master Calendar , Invoice_detail, RetailerMaster tables each of the table has linked together. Here for example under the distributor i have 10 retailer 8 retailer has bought the product for current month July. Remain 2 is not bought single product in current month but they bought in previous month. I have to create the report as below

Distributor	Retailer	Bought	Not Bought
1	1_001	12/07/16	-
1	1_002	12/07/16	-
1	1_003	12/07/16	-
1	1_004	12/07/16	-
1	1_005	12/07/16	-
1	1_006	12/07/16	-
1	1_007	12/07/16	-
1	1_008	12/07/16	-
1	1_009	-	12/06/16
1	1_010	-	12/06/16

But While i'm selecting the Year and month from Master Calendar table QV automatically filter the current month invoice detail. So i'm unable to fetch previous month detail for that missing two retailer (1_009,1_010) Please find the attached screen shot for this app.

Any one please help me to resolve this.......

[inescastelhano]

Assuming that you have an expression in your table, make sure you include something like:

sum({<YourYearField=, YourMonthField= >} FieldToCalculate)

to ignore the selected date.

Cheers,

Ines

[#3]

Hello Castelhano,

Thanks for reply.

Yes i have wrote same in table but problem here is while i'm selecting current month QV automatically filter the record for current month. First I need to find not bought retailer details for current month and i need to find they were bought product for previous month from the same table.