Display value at end of period
I am designing a universe which returns sales and assets, and have a time hierarchy like Year->Quarter->Month->Date. If I include the Assets measure in a report, the default behavior is to summarize, which is fine for all the other measures.
What I need to happen is that the report would display the last value in the period for Assets.
Assets and Sales are in separate tables, but I could combine them. I'm thinking that being in separate tables might be a benefit in this situation.