Pivot table functionality in Business Objects

[former_member1113912]

I am trying to pivot data in business objects from a report that has multiple rows of sales data for each sku. I want to have just one row for each store/sku and average various data points. When I try this with a vertical table I get #multivalue errors for almost every data point. Any other suggestions?

[nscheaffer]

Can you provide a screenshot of what you are trying to do? Are your object dimensions, details, or measure?

[former_member1113912]

I need to show store no, sku, and then average of safety stock, reorder point, reorder qty, repl inv units, and over/(under) stocked.

[former_member1113912]

To give a little more context, I had to show separate rows for all the weekly sales so I can calculate standard deviation, but ultimately I need to consolidate that to one row per store/sku.