metropia
asked on
how to make month name dynamic on pivot table
Hello I have a stored procedure that at the end of it, produces a pivot output by month_quantity
The 12 months are static and I would like to learn if it is possible to, using the data, and code I have, to make the column names dynamic instead that always returning twelve.
I will use this code to later feed a SSRS report, that is if the column month names can be created dynamically.
Any information and/ or examples would be really appreciated.
Thank you very much.
p.s.
I attached some data and the code that produces the prepivot table and the output pivoted data set
pre-pivot-and-pivoted-output.txt
pivot-data-sample.xlsx
The 12 months are static and I would like to learn if it is possible to, using the data, and code I have, to make the column names dynamic instead that always returning twelve.
I will use this code to later feed a SSRS report, that is if the column month names can be created dynamically.
Any information and/ or examples would be really appreciated.
Thank you very much.
p.s.
I attached some data and the code that produces the prepivot table and the output pivoted data set
pre-pivot-and-pivoted-output.txt
pivot-data-sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER