How to ignore a particular dimension and sum up qty in vizlib pivot table?

[Mona]

Hi,

I am working on laptop sales visualization using vizlib pivot table. I can't make the total sum of model order correct when switching from subgeo level to geo level.

Below is my sample data, 

Geo	Subgeo	Model	Parts	Parts Order	Model Order	Percentage
AP	ASEAN	FXX	S144	60	2,420	2%
AP	ASEAN	FXX	S145	2,138	2,420	88%
AP	ASEAN	FXX	S146	22	2,420	1%
AP	ASEAN	FXX	S147	200	2,420	8%
AP	HTK	FXX	S144	100	100	100%
AP	HTK	FXX	S145	0	100	0%
AP	JAPAN	FXX	S144	250	250	100%

Vizlib Pivot Table allows you to remove dimension, so after remove subgeo dimension, the table is as shown as below:

Geo	Model	Parts	Parts Order	Model Order	Percentage
AP	FXX	S144	410	2,770	15%
AP	FXX	S145	2,138	2,520	85%
AP	FXX	S146	22	2,420	1%
AP	FXX	S147	200	2,420	8%

Model Order in Geo level should be 2420+100+250 = 2770.

How should i modify my formula to ignore Parts, and sum up Model Order to Geo level? or if you have other idea, please also share with me 🙂

I've also attached my formula of meansures and tables structure:

Geo	Subgeo	Model	Parts	Parts Order	Model Order	Percentage
Geo	Subgeo	Model	Parts	=sum(PartsOrder)	=sum(ModelOrder)	=sum(PartsOrder)/sum(ModelOrder)

Table1: PartsSale

Geo

Subgeo

Model

Parts

Parts Order

Table2: ModelSale

Geo

Subgeo

Model

Model Order

Thanks in advance.

I am a Chinese, hope my explanation is clear enough for you.

Regards

Mona