1 person found this helpful
The solution would be to find why you have a different result in grand total.
Is grand total really the sum of the details you see above?
All your "Received quantity" have a month and a supplier defined?
If in your model you have inner join as soon as one single row of data his missing a join on month or supplier the 2 grand total will be different.
So do some analysis on your data to find out what is generating the delta you see in your figures.
In addition to what Gianni wrote you should also check your hierarchies.
In particular, the columns used to make up a level key should reference a unique value. If the level value is not unique, columns need to be added to the key to guarantee uniqueness.