Ignoring selections for chart dimension

[#1]

Hi,

I'm trying to ignore any selection given for TransactionWeek  in a chart.

In the expression I have used: sum({$<TransactionWeek= >} LegFare) but doesn't seem to work.

Can anyone help?

[sunny_talwar]

There is a hidden field in your data base called _LYDate which you also need to ignore because there is selection made in that field as well

Sum({$<TransactionWeek=, _LYDate>} LegFare)

Is this not working?

[MarcoWedel]

Hi stalwar1,

did you practise divination lately or how comes you knew?

regards

Marco

[sunny_talwar]

Marco -

I have been learning some woo-doo lately... Just tried to check if it worked today.

[trdandamudi]

Sunny,

I had the same question like Marco, now I know the answer...

[#6]

Hi,

Great this working for TY.

This year is working:

=sum({$<TransactionWeek=, _LYDTE >} LegFare)

But Last Year is still not working:=sum({$<TransactionWeek= ,_LYDTE, TransactionDate = altDAY::TransactionDate, _LYDAY, TransactionYear>}LegFare)

Any ideas?

[#7 · Accepted solution]

stalwar1‌

=Sum({$<TransactionWeek= ,_LYDAY, TransactionYear = p({altDAY<TransactionWeek, _LYDAY>})>}LegFare)

[sampada0810]

You can use set analysis to ignore the dimensions

for eg.

Sum({$<Region=>}Sales)

This will return the current selections value ignoring the region selection