Skip to Content
0
Jul 22, 2016 at 08:43 AM

Aggregate key figures

98 Views

Hi,

I would like create a Report with Lumira how has this key figures function. The data source is excel file.

This are the base data

Customer Region Location Number contract 21000000 Bern Thun 7 21000000 Bern Biel 7 21000000 St.Gallen Gossau 7 21000002 Bern Biel 4 21000004 Bern Thun 2

If i delete the object Customer i should have this data with this number of contract.

Region Location Number contract Bern Thun 9 Bern Biel 11 St.Gallen Gossau 7

If i delete the object Location i should have this data with this number of contract.

Region

Number contract

Bern 13 St.Gallen 7

In BW Query this function is Exception Aggregation

Can somebody help me.

Thanks