Hi Karthik,

Hopefully this is what you want!!

Thanks

Sandeep

Hi Kartik,

I guess you required help from LOD{} in this scenario.

For All you may try this calculation

{SUM(Value)} //This will always returns the total value until you don't use any context filter on any dimension in your view.

Give a try and let us know if this help.

Another way using parameter.

Mahfooj

Hello Karthik,

I think Sandeep's solution is the simplest one. Still, you need to update the test of Grand Total on axis. Just right click on axis and select format. Change the text in Label text box.

TG

Hi Karthik

Create query as

SELECT [Orders].[Category] AS [Category],

  [Orders].[OrderDate] AS [OrderDate],

  [Orders].[OrderID] AS [OrderID],

  [Orders].[Profit] AS [Profit],

  [Orders].[Quantity] AS [Quantity],

  [Orders].[Sales] AS [Sales],

  [Orders].[Segment] AS [Segment],

  [Orders].[SubCategory] AS [SubCategory],

'Data' as [Data]

FROM [dbo].[Orders] [Orders]

Union All

SELECT [Orders].[Category] AS [Category],

  [Orders].[OrderDate] AS [OrderDate],

  [Orders].[OrderID] AS [OrderID],

  [Orders].[Profit] AS [Profit],

  [Orders].[Quantity] AS [Quantity],

  [Orders].[Sales] AS [Sales],

  [Orders].[Segment] AS [Segment],

  [Orders].[SubCategory] AS [SubCategory],

'All' as [Data]

FROM [dbo].[Orders] [Orders]

Create Calculation as

if ['Data']='Data' then [Category]

else 'All'

END

Drag this calc into row and sales into column.

Thanks

sankar

Yes for drill through thats right way to do.

If my reply helped you to solve your query then please mark my reply as answered one.

Thanks

Sandeep