How to show data in summarized form(Aggregated)?

Hi,

I am facing a basic issue and I am try to show below in aggregated form in a grid table.

Region  Product Sales
EAST Phone 10
WEST Phone 30
SOUTH Phone 20
WEST CHAIR 25
WEST CHAIR 40
NORTH DESK 50
NORTH DESK 100

but when I apply the sum function with over "Sum(Sales) over ([Region],[Product])" I get the below result.

Region Product Sum([Sales]) OVER ([Region],[Product])
EAST Phone 10
WEST Phone 30
SOUTH Phone 20
WEST CHAIR 65
WEST CHAIR 65
NORTH DESK 150
NORTH DESK 150

But What I really want is this.

Region Product Sales
EAST Phone 10
WEST Phone 30
SOUTH Phone 20
WEST CHAIR 65
NORTH DESK 150

The Summarized Values. Please if there is way to that let me know it's really urgent and Important.

 

Regards,

Hassan

1 Comment

Hi Richierich,

 

The the solution you gave me works fine with the base measure but it does not work with calculated feild. 

Is there any way that we can get the same results with the calcuted field also?

Regards,

Hassan

hassan.asif - May 28, 2019 - 3:42am ::
+ Add a Comment

(1) Answer

Login