I'd like to introduce a new measure into QS which is the multiplication of two existing measures, e.g. Total Weight Product = Weight per Piece X Number of Pieces, I've got both as a Dimension into QS, how can I create this new variable/dimension?
thanks - have done this before, however can you show me an example of a new dimension (WeightShipment) that is the multiple of the output of two existing measures, I seem to write the expression not in the correct way, i've put in the FX box:
However when I try to then create the Sum of the WeightShipment it only gives me the WeightperPiece (as if it did not take into account the expression.
YOu could create a new measure or dimension as a master item. This can then be used over and over again in other charts and if you change it The changeapplies across all the charts it's in use in. One draw back is at the moment you cannot use a mastert item directly in another expression.