Skip to Content
0
Jan 05, 2023 at 04:39 PM

Fixing the number of column in a Cross-Tab report

39 Views

Hi,

Il have a cross tab that display the number of accident by year (in column) and by accident type in line.

I présent the last 5 year un the cross-tab. at a division level and at the driver level.

It work find but at the driver level, if the driver did not have any accident in 2019, the column woul not appear and the cross-tab will only have 4 columns

Is it possible to fix the number of column and have an empty cell if there is no accident.

exemple.jpg

in this exemple there is no data for 2021 and 2023

Thank

Attachments

exemple.jpg (17.5 kB)