how to ignore Filter selction on MultiBox Date field

[Anonymous]

Hi Champs,

I have a multiBox with Month&Year format (like Jan-16,Feb-16 etc.,) and how to ignore a filter selection on this MultiBox which is in the date format.

I have an idea to implement using for other aggregation  SUM({<[SalesType]=>}Amount),but How to write the same when we have date filed in Multi box

In-Advance

Thank you

[#2]

Hi anil, I think that you should create Month&Year format as a field in script.

For example:

Month & '-' & Year AS MonthYear

And then, in expression

SUM({<Monthyear=>}Amount)

Hope it helps !

Regards,

[sunny_talwar]

Unfortunately there is not much information to go in details, but may be put this Multi box object in a alternate state.

[Anonymous]

I have date filed in Multi Box over the  Pivot table.Filed Name is msp3_CalenderMonthWithYear(MMM YYYY foramt) .

I have one more Generic filter; Gender which contains male and Female,my scenario is that Gender section should not effect my date filter.

I tried in MultiBox Expressions as ,but no luck

=MinString({<[Gender]=>}msp3_CalenderMonthWithYear).

[Anonymous]

Experts ,

Need some suggestions