As per business requirement i should give explicitly excel icon in the dashboard where users can click on excel and see the downloaded data in .csv file.to achieve this functionality , i am able to pass required filters to the excel download and data also getting downloaded into .CSV but not like desired format.
that data should display like below screen shot in excel.(1st screenshot)
As i said in above functionality, the data is displaying like below (2nd screenshot)
Can someone help me to achieve first screen shot functionality in excel download
Unfortunately there's no way to do exactly what you'd like. The best you can do is have the user download crosstab, or do something like this blog The Greatest Tableau Tip EVER: Exporting Made Simple!
Let me know if this helps, and mark it correct or useful if it was!