ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Too many rows or columns in my pivot-table (https://www.excelbanter.com/excel-discussion-misc-queries/104835-too-many-rows-columns-my-pivot-table.html)

markus

Too many rows or columns in my pivot-table
 
Hello, I have an issue with my pivot-table.

I have two right-hand-side columns and one left-hand side one

Like this: Customer..Ordernumber.....................Total renevue

I would like to get the articles that the customer bought as well when I
click the ordernumber, but Windows tells me (translated from Swedish) that I
have too many rows- or columnelemnents, and that I have to withdraw at least
one row- or column element.

Is there any way to get around this problem?

markus

Too many rows or columns in my pivot-table
 
Hrm, that should be: I ahve two left-hand side coulums and one right-hand
side, sorry!

"markus" wrote:

Hello, I have an issue with my pivot-table.

I have two right-hand-side columns and one left-hand side one

Like this: Customer..Ordernumber.....................Total renevue

I would like to get the articles that the customer bought as well when I
click the ordernumber, but Windows tells me (translated from Swedish) that I
have too many rows- or columnelemnents, and that I have to withdraw at least
one row- or column element.

Is there any way to get around this problem?



All times are GMT +1. The time now is 03:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com