Skip to Content

I have a count (Any numeric)  coming from my fact table (Which is column-1) , but I wanted to calculate the total of all column-1 which is 4577733 then I need to do division ,column-1/column-2 which is column-2 then use this sum to calculate the some (DIV)average.


/wp-content/uploads/2014/06/1_484447.png

The issue is the moment we put the “TYPE” in to the output, the numbers will be lined up to the Individual type which is as you see in column1 .But the objective is to get the total sum which 4577733 then divide it by column1. There could be many alternatives .But below is one of the option.

Here all these numbers are coming from the same table. So I wanted the sum (4577733) to be at the aggregated level.  In order to do that I need to use the same underlying table twice in the calculation view , on one side it will be aggregated at the “TYPE” level and on the other calculation data will be not be rolled up to the “TYPE “ level. We need to roll up the data in to 2 different levels as below.

This can be achieved using the calculation view.

/wp-content/uploads/2014/06/2_484460.png

Please notice here, there is no aggregation level. It’s just rolled up to the key figure.

/wp-content/uploads/2014/06/3_484461.png

Then next aggregate by type /category ,STVEHCAT & key figure.

.

/wp-content/uploads/2014/06/4_484462.png

So we will be using the 2 different aggregation levels to roll up the numbers (Same base table). Please note here that you are linking the 2 aggregation level by key figure only

/wp-content/uploads/2014/06/5_484463.png

/wp-content/uploads/2014/06/6_484464.png

/wp-content/uploads/2014/06/7_484465.png

/wp-content/uploads/2014/06/8_484466.png

Use the data Preview.

/wp-content/uploads/2014/06/9_484467.png

Thanks

Ramakrishnan Ramanathaiah

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Sarhan Polatates

    Hi Ramaksihnan,

    the document that you have posted might be more useful if you put it in a business flow instead of using column x,y. You can use labels like; number of orders, total sales amount, etc…

    (0) 

Leave a Reply