So, if we go each chart at a time, do you know what are the numbers you expect to see in the first chart for example? I mean I am sort of not very clear as to what you are trying to convey here
If you look at the first tab, VSI and VSI-D Forecast Readiness, I'm trying to calculate the number of CPU's and Memory amount for each row listed.
What you be able to convert the above def. into numerical terms. I know you have been providing a lot of details, but not sure why, but still having a lot of difficulty to understand what is needed here.
My apologies for the delay in responding. I believe your initial assessment of the calculated dimensions conflicting with the expressions is what my problem is. So, I’m in the process of changing the data model. I’m not sure if it’s going to work or not, but we’ll see. As always, thank you for your help and I’ll let you know how my changes go.
Hello Sunny (and Anyone Else Following this discussion):
So, I've solved the problem, but it took you (Sunny) to point it out. In this case, I cannot have an item with three rows where the item_sku is the same. It just won't work. So, I eliminated the duplicate item_sku numbers, tweaked my calculated dimensions and expressions and viola! I'm now getting what I was after which was a top 20 listing by quantity to include the associated CPU and Memory quantities.
Many thanks to Sunny for pointing out the conflicts I had between the calculated dimensions and expressions.
Sunny, I will mark your last response in that regard as the correct response, As always my friend, thank you for your assistance. It's always appreciated. Happy Holidays!
