I got a pivot table with several dimensions and expressions
Actually this pivot table is heavy i.e. if the user is not filtering any country or all countries are selected I get out of object memory message on the chart
to overcome this I put a calculation condition that says that the user has to select only one country!!
For now it's fine
now is there a way to export this pivot table with all countries included without actually selecting the countries and be displayed on the sheet?
ok on the sheet I oblige the user to select only one country but he can export the pivot table with all countries
