Urngent Help in Pivot conversion in to qliksesne!!!

[srini]

I have a scenario like below in the attached file I have two parts one is source and another one is output. 

Source:

in the source there are two parts

one is raw data which is highlighted in grey.

Another one is derived using SUMIF from raw data to use in Pivot table.

Output

output is excel pivot which consist of Raw data and derived data. 

Question:

I need this to be achieved in Qlik Sense. I have tried with some cross table concept but not getting the exact value....

any steps to follow advise solutions? really frusturated 😞

Thanks!

[srini]

Yes, I need use those fields in another resident table in future. that is the reason.

[sunny_talwar]

You can still use them if they are in Test1? I guess I am not sure why do you need them to be in Data?

[srini]

ok, still if I use them fine. if I remove the data table the issue will be resolved ?

[sunny_talwar]

Give it a shot and let us know 🙂

[srini]

it is working fine topnotch! can we use two Cross tables with same source. i.e I have units for twelve months and charges for twelve months. 

I need all twelve month Units as Month, Units

and 

Twelve months charges Month, charges

is that possible?

[sunny_talwar]

My friend why do you hesitate to try.....give it a shot and find it for yourself.

[srini]

Hi Friend, Sorry... I will try and let you know. Thanks!