示例=CUBEVALUE("Sales","[Measures].[Profit]","[Time].[2004]","[All Product].[Beverages]")
以上是offic自带帮助的示例
如果对于All Product这个字段,假设要同时满足Beverages和Water的和时候要怎么写?求大神指导下。请不要用=CUBEVALUE("Sales","[Measures].[Profit]","[Time].[2004]","[All Product].[Beverages]")+CUBEVALUE("Sales","[Measures].[Profit]","[Time].[2004]","[All Product].[Water]"),因为我主要是要算同比用,谢谢! |