I have a report connected to the IM_ItemWarehouse table and need report manager to aggregate warehouse values. I have filtered down to two warehouses but I need to report items of these two warehouses in aggregate. Its creates duplicate rows in my pivot. In the example below collapsing this item will blank my text.
I'm assuming that you have joined the IM_ItemWarehouse to the CI_Item
The IM_ItemWarehouse stores the Qty's as a sum for each Warehouse.
So when your report is generated Sheet1 should show Item…
Instead of doing the WH filter in the Pivot Table use a filter in the Report Manager like this:
Now the raw data is just items in WH 001 or 002.
The Pivot table would look like this:
Remove the…
yes i know i can do that in the pivot but there are other fields tied to the rows of data where that wont work. For example, displaying comments. comments are based on item but because of two warehouse…
I'm assuming that you have joined the IM_ItemWarehouse to the CI_Item
The IM_ItemWarehouse stores the Qty's as a sum for each Warehouse.
So when your report is generated Sheet1 should show Item, Prod Line, WH and the total Qty's.
I created a Pivot Table and it looks like this
Is this what you were going after?
I used the ABC Demo data
Instead of doing the WH filter in the Pivot Table use a filter in the Report Manager like this:
Now the raw data is just items in WH 001 or 002.
The Pivot table would look like this:
Remove the WH Col
Turn off the Automatic Subtotals and you end up with this:
Is this what you were looking for?
