Datamodel help ???

[amit_saini]

Hello Experts,

This Finance requirement is somehow complicated , but I'm sure I will get some help.

Data Source looks like below (Refer Source_Data Tab in attachment)

Not sure how can I deal with Month , Volume Months.....and Net Sales Month by using cross table or some other function.

Target Result required: (Refer Result tab in attachment)

Thanks in advance!

AS

[amit_saini]

Any Suggestion???

Thanks,
AS

[Anil_Babu_Samineni]

Is it possible to share the Excel, It seems Transpose only. I don't think how much complex it is

[amit_saini]

PFA

[#5]

Hi Amit,

I have an idea for the above result to be produced.

Attached the qvw, Kindly go through it.

If it is the same as you expected, you can use it.

Regards,

Vivek

[Anil_Babu_Samineni]

May be look this

CrossTable([Month-Names], Sales, 4)

LOAD * FROM

(ooxml, embedded labels, table is Source_Data);

And then Create Pivot Table with the Dimension as

Dim1 ='Sum Of ' & [Month-Names]

Dim2 = Month

Expression is Simple

Sum(Sales)

And then Transpose Month as Vertical - Horizontal. Then Sort where ever you need

[sureshsindhigi]

Hi Amit,

Please find attached result QVW file, hope this will be working for you're a requirement.Thank you.

Regards,

Suresh Sindhigi