Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a master calendar that reduces the data table for 2 sets of tables from one selection in the master calendar.
These are keys generated in the load script.
[Open Balance Table] KEY_Open Balance Date < Master Calendar > KEY_Fact Date [Fact Table]
> Any selection in master calendar reduces the tables either side
How do I then transfer selections made on the fact table to the Open balance table.
Do I need to use set analysis and get field selections? or is there another way?
COUNT({<Open_Balance_CountryID={[CountryID]}>} CaseID_Open_Balance)
Thanks,
Try it with p():
COUNT({<Open_Balance_CountryID=p([CountryID])>} CaseID_Open_Balance)
- Marcus
I don't fully understand your issue, but for transferring selections from states in set analysis you can do as follows:
=SUM({$<Field1=SetName::Field1>} Field2)
Lets say that we want to sum all values in Sales field on the state X but considering the dates of the current selections, it would be:
=SUM( {X<Date=$::Date>} Sales)
Or sum the budget for all data except for region that will be considered based on current selections:
=SUM({1<Region=$::Region>} Budget)
Hope this helps.
Kind regards,