Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Would you be able to share some sample data and explain the output you are looking to get?
See attached Word document that explains my requirement.
Thank you,
I guess I am still not sure how you imagine seeing this in the pie chart?
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.
Sorry but still not sure... may be someone else can offer you help.
Best,
Sunny