Expression based on Dimension Help?

[amit_saini]

Hi Folks ,

I'm having one Material Number which goes through some levels say Level1 , Level 2 , Level3 ...etc.

For example in below pivot table Material Number 1024936001 is having links in other level. Here based on these levels I'm calling Quality as expression, but looks like something is wrong here. I'm getting duplicates entries like 1700 ,1700 etc.

But if I'm calling only level 1 than getting perfect values , see below:

Here what I want is to show all Levels and Description as above in first image, but Quality numbers should be based on Level1(Dimension).

Kindly help here.

Thanks,

AS

[anbu1984]

Using your quantity expression in UI gives same value. Is this really duplicate? Did you verify by calculating quantity manually?

Check whether data is properly loaded in the table UnitCost