The sales department has requested a change to a tabular account report and wants to be able to analyze the monthly amount of each Account name by Year.
The report author changed the original report on left to the report on the right.
How was this done?
To transform the tabular report into a crosstab format where the columns are Year and Amount (month), you would typically select a meaningful categorical column like Year, as it becomes the header in the crosstab. Using the toolbar button 'Pivot List Crosstab' is the appropriate tool for this transformation.
incorrect B) is correct https://i.ibb.co/9YBH4Z4/pivot.png