Understood, Thanks but please suggest (if any) using TOPN( ) can we get rid of that rank number in TOTAL row. Asking because if i leave RANK column formula with TOPN( ) then once i set aggr rule as NONE for RANK column, i can still see rank values which is better than when using RANK in column formula. Regards.

Hi Gianni, As you mentioned, i switched formula from TOPN( ) to RANK( ), and set the aggregation content on RANK column to "NONE" and applied filter on the report column using presentation variable (because we need the flexibility for users to select top 3 ranks or 5 ranks or 10 ranks etc. But after this i don't see any…

Hi Gianni, Formula for Rank -- TOPN("FACT"."$ Demand Items TY",10 BY "DIM"."SAP Category") Its a simple report - no unions OBIEE version - 12.2.1.4.0 Thanks

Hi Gianni, Please see below screen shots. 2nd screen is the actual report and first screen shows where i selected "after" to totals. In the 2nd screen shot i want to see totals for all measures, but don't want to see any rank number for the "grand total" row (last row) Hope now you got what i am saying.

HI Gianni, For the "columns & Measures" in "edit table view" i selected as below so that to show totals of measures for each section. If i select "none" in below, then i don't have any issue. Please let know if this is causing the issue. Thanks.

Hi Gianni, It did not work, i still see the rank number in Grand total row.

Hi Chris, We have only one prompt of date type, rest are region, currency etc. This prompt values are expected to be shown as report heading (narrative view). Thanks.

HI Gianni, I want to alter the date format ONLY for this prompt values. Not for the entire system. Please suggest. Thanks.

Hi Chris, Thanks for the input, but all i can access is the column formula f(x) of that column, not the column properties where we can assign a custom date format. This prompt column do not exist in the report criteria. Thanks..