Hi there If I have a dataset that looks like the following: Division PeriodType Budget Actual A 1 500 200 A 2 700 300 A 3 100 500 B 1 300 800 B 2 400 700 B 3 100 300 How can I extract a specific value from this query? Say, I want to get the Actual for Division A in Period 2 which is 700 Thanks
The dataset has filter tab for setting this in it's property pages. Another route is to filter in the display control, if it's a data region, such as a table or list. Thanks, Steve MunLeeuw
Thanks Steve That's not really what I was looking for I have a dataset that contains the profit for a particular associate company in our group. When I create the balance sheet, I need to add this profit to the investment portion that I calculate using another dataset. Take into account that both datasets are populated from the same AS cube. The matrix I then use to display the data contains a time dimension to calculate the balances for the current month, same month last year, ytd and ly ytd. On Fri, 8 Aug 2008 11:50:42 -0600, "Steve MunLeeuw" wrote: >The dataset has filter tab for setting this in it's property pages. Another >route is to filter in the display control, if it's a data region, such as a >table or list. > >Thanks, >Steve MunLeeuw >
Can you create a calculated member on the client and use that? Thanks, Steve MunLeeuw
