Solved Mixed Layout

[Erin M 2021]

I have created a report based on two groupings: Campaign and FY. I need to change this report to show campaigns on the y-axis and then give me the detail of each FY horizontally. Any guidance on how to do this?

Thanks in advance,

 

[mike60smart]

Look at Crosstab Queries

 

[plog]

How many fiscal years do you expect to show on the report? Is this always true? If you have 3 this year, will you see 3 next year? Or will you see 4?

 

[mike60smart]

I have created a report based on two groupings: Campaign and FY. I need to change this report to show campaigns on the y-axis and then give me the detail of each FY horizontally. Any guidance on how to do this?

Thanks in advance,


View attachment 92972

Can you upload a zipped copy of the database?

 

[Erin M 2021]

Look at Crosstab Queries

Exactly what I needed. Thanks!