Creating a pie chart where the expression is a product of a dimention and another expression?

[viralkmehta1968]

Hi,

I need to create a pie chart with one dimension and 2 expressions as follows:

Dimension: D1

Expressions: 1) Number of Units = COUNT(DISTINCT UNIT_ID)

                    2) TEU = Number of Units * Length/20 where Length is a dimension (not a measure) that I do not want to use in the pue chart.

Thank you,

Viral Mehta

[sunny_talwar]

Would you be able to share some sample data and explain the output you are looking to get?

[viralkmehta1968]

See attached Word document that explains my requirement.

Thank you,

[sunny_talwar]

I guess I am still not sure how you imagine seeing this in the pie chart?

[viralkmehta1968]

My pie chart will have 1 dimension - LINE and 1 expression - 'Inventory Units' But the calculation of invebtory units (as I mentioned earlier) involves a dimension (LENGTH)  not used in the pie chart.

Hope that makes it clear.

[sunny_talwar]

Sorry but still not sure... may be someone else can offer you help.

Best,

Sunny