Group by a dimension.

[markgraham123]

Hi,

I was trying to group the data w.r.t the dimension Warehouse.

When a warehouse is selected , intstead of seeing all the records with a total in a table.

I wanna see only the total of the data in the columns.

Please look at the atatchment - Table "0-8 WOH"

[sunny_talwar]

Can you reduce the size of the document?

[markgraham123]

Hi Sunny,

I tried to. I was not able to reduce the size.

Here is the screenshot for your reference.

I was trying to have only one column, which shows the total sum of SKUs, pallets, and units.

Instead of many columns.

[markgraham123]

If((Sum([Qty On Hand])/([360-day Velocity]/52))>=0 and (Sum([Qty On Hand])/([360-day Velocity]/52))<=8, Count(Distinct(SKU#)))

If((Sum([Qty On Hand])/([360-day Velocity]/52))>=0 and (Sum([Qty On Hand])/([360-day Velocity]/52))<=8,Sum([Units Packed]))

If((Sum([Qty On Hand])/([360-day Velocity]/52))>=0 and (Sum([Qty On Hand])/([360-day Velocity]/52))<=8, Aggr(Count(LBCD),SKU#))

These are the exp. used

[sunny_talwar]

Great and is this the part you are looking for?

and nothing below it, right?

[markgraham123]

Yes.

Exactly.

[markgraham123]

With a warehouse name.

[sunny_talwar]

Try this:

If(Dimensionality() = 0, YourExpressions) for all the three expressions and see if that does the trick for you.

Best,

Sunny

[sunny_talwar]

Which warehouse name?

[markgraham123]

Derz a Warehouse name OB2 mentione din the screenshot.

All the values correspond to that.