Group measures in Pivot Table

[tan_chungkam]

Hi qlikers,

I have posted similar question yesterday.

However I have different scenario.

I have 3 table contains different fields.

I would like to group those measure - [Import Sales & Export Sales] / [Air Freight & Shipment] / [Installation & Packaging] in the Pivot Table.

Anyways to do it?

[durgesh22]

Use below definition while creating measures,hope that solve your problem.

Import Sales&Export Sales = Sum([Import Sales]+[Export Sales])
Air Freight&Shipment =Sum([Air Freight]+Shipment)
Installation&Packaging =Sum(Installation+Packaging)

[tan_chungkam]

Thanks for the advice.

However I am looking for Group up instead a sum up of 2 fields.

[mfarsln]

Hi Tan,

You need to join them and then use crosstable. You can check the attached file.

[tan_chungkam]

Hi @mfarsln ,

Thanks for your instruction.

The data presentation is perfect.

However the figure itself are wrong.

Import & Export Sales figure is multiply how many Sub ID of the ID.

 

[mfarsln]

Hi Tan,

This is because you don't have any sub id information on import&export sales sheet. So it duplicates normally. I think you are gonna need to add Sub ID data to sheet1. Or -the better way- is to gather measures in one sheet and add sub ID or ID to those measures. It depends on how do you want to analyze data. As i said, if you want to analyze it based on sub id, then the values must be cluttered to sub ids.