Hello,
Im trying to export a pivot table to excel using a macro,which is succesfully exported.
1.How can we calculate the mean and SD as shown in image while exporting in qlikview itself?
2.How can I export with the background colors like shown below fig 2?
3.The description is not a field that is available in qvw,so how can we add that row?
4.Also the index for reference(colour and its meaning)?
Now when I export I get the data as shown:
![Athira_K_1-1646105456438.png Athira_K_1-1646105456438.png](https://community.qlik.com/t5/image/serverpage/image-id/73236i09652BF18E95C046/image-size/medium?v=v2&px=400)
My requirement is to export it in the image shown below:
![Athira_K_0-1646104761139.png Athira_K_0-1646104761139.png](https://community.qlik.com/t5/image/serverpage/image-id/73235iB287BEEF0F3F2325/image-size/medium?v=v2&px=400)
How can we implement it?
Thank you