Problem in deriving Aggregated sum based on a Field

[Anonymous]

Hi. Good Afternoon.

Before going forward with the problem, please refer to the situation where I am representing the following data in a Pivot table:

Warehouse	Plant	Occupancy in %
K01	A016
	F013

Occupancy in % = sum([Bin Occupancy]) of Plant / SUM([Bin Occupancy]) of 'Warehouse'  * 100

** where [Bin Occupancy] is a calculated value

I am unable to get the Aggregated sum based on the 'Warehouse' with the below expression. Tried several ways but the problem persists.

=sum([Bin Occupancy]) / aggr(([Bin Occupancy]), Warehouse)  * 100

Please assist.

Thank You.

Regards,

Vijit

[#2]

Hi,

try like this.

   (aggr(sum([Bin Occupancy]),Plant) / aggr(sum([Bin Occupancy]), Warehouse) ) * 100

if this will not helpful for your then please attach sample file here.

Thanks,

Ashutosh

[#3]

Hi Vijit,

Did you gave a try using Total as below?

Occupancy in % = sum([Bin Occupancy]) of Plant / SUM(Total [Bin Occupancy]) of 'Warehouse'  * 100

=sum([Bin Occupancy]) / aggr(Total ([Bin Occupancy]), Warehouse)  * 100

Regards,

NR

[Anonymous]

Hi.

Either case, it's not functioning. Please also make a note that Warehouse has two values = 'K01' and 'B01'

Regards,

Vijit

[Anonymous · Accepted solution]

Hi.

Even after using dimentionality() function, I found a simple solution:

= Sum([Bin Occupancy])/Sum(Total <[Warehouse]> [Bin Occupancy])

Regards,

Vijit