Jump to content
We've recently updated our Privacy Statement, available here. ×

How to show data in summarized form(Aggregated)


Hassan Asif

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...