Calculated Dimension Issue

[#1]

Hi

I am facing an issue to create a object.I have a Excel file with sheet names A,B,C as a source file.now i need to create a object based on the sheets like below.

Expected Output:

Please find the attached Sample excel file as reference.

The value 30 under Jan(Period -A) is the sum of values coming from Sheet A Jan values.same way the remaining values

[sunny_talwar]

So data comes in a form of a pivot table where Months are pivoted? or is this just for demonstration purposes?

[#3]

Hi Sunny,

Thanks for reply.

Data is not coming in the form of pivot table.its directly fields names with values.

[sunny_talwar]

Would you be able to share how the actual data is coming?

[#5]

Attached file is the sample data file.

Please find and let me know if any details required.

Thanks

[Anonymous]

only periods a,b and c exist?

[#7]

Yes only periods a,b , c exist.i need to show now total values as a sum under Jan,Feb,Mar......till Dec against Period Dimension and Difference also from total values.

[sunny_talwar · Accepted solution]

Check out the attached

[Anonymous]

...

[#10]

Thanks Sunny.Its working fine