All geek questions in one place

MS-Access Pivot Chart

Can someone help me sort and organize a pivot chart in MS-Access, please. I could do this easily in MS-Excel, but not in MS-Access. I need a gap between each task + Budget in the MS-Access table in the same way as in MS-Excel. If you put an empty entry in the Access table, sorting becomes a problem. Actually, sorting the X axis is not flexible enough in MS-Access and just sorted alphabetically. thanks enter image description here

+4
source share
2 answers

This is one way to implement the Sten solution.
Create another column in the query and merge it with existing data

Select Replace(Task," Budget","") as TaskGrp, Task, Employee, Amount From Table1 Union Select Replace(Task," Budget","End") as TaskGrp, Null, Null, Null From Table1 Where instr(Task,"Budget") > 0 Order By TaskGrp, Task, Employee

Then skip TaskGrp when you run the chart

+1
source

Yes, I mean adding a space value. "". Technically, the space will be displayed on the chart, but no one will be able to see it. You may have an extra column that is not included in the graph for sorting.

0
source

Source: https://habr.com/ru/post/1479632/

More articles:


All Articles