How to use 'Total' in case of multiple dimension values

[#1]

Hi,

I am having dimensions  as Model,Version & Defects.

Data:

Model	Model Version	DEFECTS	Quantity
X	AX	LAMP	2
X	BX	BRAKE	1
Y	B	LAMP	2

Summary:

Model	Total Cars Produced
X	2
Y	1

Out put needed in straight table:

Model	No of Defects	Average Defects per Model= No of Defects /Total Cars Produced
X	3	1.5
Y	2	2

Current expression using

Dimension:Model

Expression: Sum(Quantity)/Count(Total Model)

It gives correct result in case of Single Model selected but failed in case of multiple model.

[Anonymous]

See attached.

Marc.

[anbu1984]

=Sum(Quantity)/Count(Model)

[jyothish8807]

Hi Kauystubh,

Try this:

Dimension: Model

Exp:

sum(Quantity)/[Total Cars Produced]

Regards

KC

[#5 · Accepted solution]

Hi Marc

Thanks, your solution  will worked if another summary table introduced in data model,

but is it possible to get the desired output without loading another summary table ?

[senpradip007]

PFA. Hope it will meet your requirement.