
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ignore all selections except one filter
Hi,
I would need to get the max of year ignoring all the selections except for a particular filter .
I know i could do sumthing like Month=,Dept=, etc to ignore the selections but that would be a lot of fields to ignore.
So is there something that i could use along with the all keyword anything for that matter to disrespect all the selections except for 1 i did try something like max (all<filter name > Year) but it does not work i also replaced all keyword with Total but that does not work either.
So please let me know how this could be accomplished
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Something like this:
Sum({1<FieldToKeep=P(FieldToKeep)>}Fieldname)
Regards,
Mayank


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Something like this:
Sum({1<FieldToKeep=P(FieldToKeep)>}Fieldname)
Regards,
Mayank

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You can use alternate state ,You can make the same state of that filters and in expression use that state, this will solve your purpose.
Thanks
Paridhi

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Sum({1<Field=$::Field>} Value)
Regards,
Antonio

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you .. it's working for one filter.. what if there is requirement to consider only 2 or 3 filters. Kindly help. Thanks.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you need to filter 2 or more fields you can add as comma separated expression as below
Sum({1<Field1=$::Field1, Field2=$::Field2>} Value)
It Works.
Thanks a lot
