This question has been flagged
1 Reply
2463 Views

Pivot table icon doesn't show when you select Sales > Products> Pricelists. 

I can export to excel the price list however they appear in one column. How do I get Products and categories on the Y axis and different prices lists appearing in there own column on the X axis in excel so I can compare prices at a glance as well as using conditional formatting. 

Avatar
Discard
Best Answer

1. Activate developer mode in settings

2. Go to your required menu (Sales > Products > Pricelists)

3. Click on the "little bug" that has appeared in the top right corner next to Chat

4. Click on edit action

5. In the field "View Mode" add pivot 

It should look like this: tree,kanban,form,pivot

Make sure there is a comma and there are no spaces!

Save & Refresh


Avatar
Discard

Ya that is right,I got this issue, thanks for assist