Dimension Row & Dimension Column in Qliksense

[ch_riadh]

Hi

I have:

Dimensions Row : ShopNo

Dimension Column : Month

Expression Stock : Sum(Stock)

Expression Sales : Sum (Sales)

When I create the pivot table, it give me the Stock By Month, but it Should be One Column for stock, and then Sales By Month.

Please i want exactly this Format if its Possible or if there is an extension i can use it.

Thank You.

[Anil_Babu_Samineni]

Can you provide sample data in excel, Better approach if you would share qvw to work on it

[Gysbert_Wassenaar]

Perhaps as a calculated dimension: =aggr(sum(Stock),ShopNo)

[ch_riadh]

Sorry but how can i share an excel file with you ?