Chart not taking into account a filter

[jerryr125]

HI - can you somehow set a chart not to take into account a filter ?

I am displaying the AMOUNT on a table by particular dimension and I DO NOT want the AMOUNT to change based upon the filtering criteria.

Thoughts ? Jerry

[dplr-rn]

Use set analysis to ignore a filter e.g. to ignore any selections of filter country
sum({<Country=>} Sales)

[dplr-rn]

If you want it to ignore all filters
Sum({1} Sales)

[jerryr125]

close - how do I lock the date range ? that is - the date range does not take into account the filtered date range.

[dplr-rn]

Put the date range in the set analysis. it will lock to those dates.
e.g. sum of sales last 6 months
Sum( {<OrderDate={"<=$(=today()) >=$(=MonthStart(Addmonths(today(),-6)))"}>} LineSalesAmount)

[Channa]

=sum ( {<criteria= >} Amount)