Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
=Sum({$<TransactionWeek= ,_LYDAY, TransactionYear = p({altDAY<TransactionWeek, _LYDAY>})>}LegFare)
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?
Marco -
I have been learning some woo-doo lately... Just tried to check if it worked today.
Sunny,
I had the same question like Marco, now I know the answer...
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?
=Sum({$<TransactionWeek= ,_LYDAY, TransactionYear = p({altDAY<TransactionWeek, _LYDAY>})>}LegFare)
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