Link to home
Start Free TrialLog in
Avatar of recycleaus
recycleausFlag for Australia

asked on

Cannot get PivotTable to work

I am trying to turn the attached table into a pivottable however for some reason it is not working.

If someone can help that would be much appreciated.

Thanks
Troy
AR_CrNte_VIC-2-.xlsx
Avatar of Professor J
Professor J
please explain, what information you need to see into the pivotable?  which columsn to show in row labels and which columns to be summed or counted?  can u plz give me more detail

do you want to learn how to create pivot table? or what is the exact issue herE?
Avatar of recycleaus
recycleaus
Flag of Australia image

ASKER

I am trying to have data organised so in terms of rows Card Name is 'Level 1' and Description is 'Level 2' in the pivottable. Then in terms of columns it would be sum of Quantity and GrosProfit.

Also I want to be able to filter by PostDate

Thanks
SOLUTION
Avatar of ioane
ioane
Flag of New Zealand image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of recycleaus
recycleaus
Flag of Australia image

ASKER

Thats perfect. How did you make the PivotTable column 'Descriptions' appear alongside 'CardName' rather than under it? I have required this many times! And then also only have the 'CardName' appear once per entry in the column?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of ioane
ioane
Flag of New Zealand image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial