Wednesday, 15 June 2011

how to show SSAS value side by side in Excel 2010 Pivot Table -


I think this question is more than one related to Excel, but what I am doing here, I have an SSAS cube Is Using Excel 2010

If rows have the same dimension for a selected period, then I want to look at the values ​​/ measures. I have tired all the pivotal choices which I know but it has no use, please help me I have attached an example below. Thanks.

Example: Enter image details here i like this Want to see data from: Enter image details here

Click on the "Design" tab for your pivot table device and change the report layout. You can choose a consistent form, outline form or compact form. Repeat All Items Label is the option that you want to choose.

I will probably select "Repeat All Items Label" and then I will change it to a table form.


No comments:

Post a Comment