Ok, it's working fine. Thanks Gianni for help.

Thanks, I will try this condition. Yes, I use this filter in Criteria.

Hi Gianni, Thanks for reponse. Ok, I create variable prompt: Presentation variable is: Dim And two Custom Values: Month, Quarter It's working fine when I use this prompt instead column selector (but now implement formule in filters). And how can I create formule in filters like this pseudocode: CASE WHEN @{Dim} = Month…

What errors? Please, write in more details what do you want to do with grand total.

Hi, Look at this: OBIEE 10G/11G - Grand Total Formatting in a Pivot view [Gerardnico] or http://www.clearpeaks.com/blog/oracle-bi-ee-11g/grand-total-conditional-formatting-in-pivot-tables

Hm, Maybe to calculate total balance and top 100 total balance you can use: top balance MAX(RSUM("outstanding balance")) top 100 balance MAX(RSUM(CASE WHEN RANK("outstanding balance")<101 THEN "outstanding balance" ELSE 0 END)) Such calculation to calculate the maximum value of the ranking of the top 100 - thats yout TOP…

Hi, In rpd you can use Power Function (it's in Mathematic Functions). For example: POWER((1+11.9/100),-0.25) * (Auth Total Interest + Auth Total Fee)

Hi, Did you tried to apply filter on measure column: IS IN TOP and there set: 100? Then you will see top 100 outstanding balances. And in custom calculation maybe you can do so: (max(RSUM(outstanding balance)) / outstanding balance)*100 max(RSUM(outstanding balance)) - maybe this is your total.

Dim - Item.Purchasing Category Hierarchy 8 is a ID, and the Dim - Item.Purchasing Category Hierarchy 8 Name is a lookup table. "Other" is only from level 3,4... Top level: Semiconduc 8: Tranzistor.. 7: Other.. Good value with using hierarchy (without prompt): And when I use columns: Top Level, level 8, level 7: The results…

Gianni, thanks for response. Yes, the correct value is 2,032,632. But when I choose the prompts Semiconduc-> Transistor -> Other (ie other level 3) it appears to me all kinds of other not dependent on Level 1 and 2. Maybe it's because after the election of the structure in the prompt, record looks like this: I think that…

Ok, I understand and it's working. But I have another question. When I turn on the prompt in going value, eg: Semi (level 1) - Trans (level2) - Other (level 3), where a semi is the highest level and the other lower. That's when choosing Other analysis shows me all the values of the Other for other top level. This should…

I think you can use Subtotal for Year/Month and Grand Total for all results.