Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello forum members,
I am facing a problem which I can't get solved. I have created a table with values from a dimension and master key values I created. As far as everything is no problem (see screenshot). I would like to create a KPI from the sum of a master key value. However, it then tells me that no double summation may take place. Since in the master key value is already summed and I enter the following in the KPI: SUM([master key value]) Is the problem in the master code or am I already going about it the wrong way?
friendly greetings
dash
Try this
SUM(aggr(SUM(MasterKeyField), DimensionField))
Hello,
unfortunately this did not help me.