OLAP Cube formula

[XLBob]

I have converted an OLAP pivot table (SSAS cube not power pivot OLAP)to cube formula, however all cells have the same value as that of grand total cell. Anyone knows how to fix this. I can't not share the workbook due to confidential info. Thanks in advance.

 

[Tianbas]

There is normally no difference for CUBE formulas if source is SSAS or PowerPivot. In most cases when I play around with CUBE formulas and they do not show what I expect a "resfresh all" helps.

 

[theBardd]

Show us what one of the value formulas looks like, and the Grand Total formula.