Hassan Asif Posted May 23, 2019 Share Posted May 23, 2019 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 More sharing options...
Richard Pobi Posted May 23, 2019 Share Posted May 23, 2019 You have to create a calculated column Colx use this expression DenseRank([sales],[Region],[Product]) After that right click your table>Properties>Data>Limit data using expression:Edit Colx=1 > Ok Link to comment Share on other sites More sharing options...
Hassan Asif Posted May 24, 2019 Author Share Posted May 24, 2019 Hi Richierich, Thanks, this worked perfectly Regards, Hassan Link to comment Share on other sites More sharing options...
Hassan Asif Posted May 28, 2019 Author Share Posted May 28, 2019 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 More sharing options...
Hassan Asif Posted May 28, 2019 Author Share Posted May 28, 2019 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now