I should have mentioned for an example that for every period we check and compare that the Historical Inventory Valuation Report is always the same am...

I have created a mock-up using excel. I took a chance again with the GI and seems to be a lot more difficult than previously thought. I was trying to ...

We had figured out a way to use an import scenario.

Grouping was and is the issue. I found that if you drill down from the dashboard chart into the GI. You can set separate navigations, so it would be l...

I found a workaround to fix this issue.

Royce, Thank you. That is kind of what were thinking; however, I thought someone may have an idea. I have used power BI before for certain things tha...

Shawn, That is what we were thinking, but we wanted to exhaust all of our options first. Thanks,

Thanks, Royce I gave that a try already and still didn't get the same number in the current balance column. The other columns are the same. That is wh...