Totals

[Former Member]

I have the following scenario

1. User enters a date range

2. Query shows say the KPI1 (Total) drilling down to the following characteristic

Office | Date | Office Type KPI1(Total)

ABC 01.01 Period 50

ABC 01.01 Modern 10

Result 60

ABC 02.01 Period 50

ABC 02.01 Modern 10

Result 60

ABC 03.01 Period 50

Result 50

ABC 04.01 Modern 10

Result 50

Overall Result 220

The overall result and the sub results are wrong they should be 240 and 60 respectively. KPI1 is a replacement path variable which is getting No of rooms from an object OfficeType which is compounded with Office.

The reason for the problem is the transactional data does not contain office types on certain days. Can I show the correct results for every day and if so how? Thanks

[Former Member · Accepted solution]

Hi

If I got your question properly, You achieve this by -- Query Designer -- KF Properties -- Calculations Tab Page -- Calculate Result as (Total) -- calculation direction -- Columns

But when you do not contain any Transaction data for Office Type, May be you can remove the Office type and use Date for calculating result.

Hope it helps

[Former Member · Accepted solution]

Thanks for this. They want to keep all three of the characteristics as part of the drilldown, however the order will not matter