1) I have a total in my pivot table. But it goes to the top. How do it make it come to the bottom?
2) I have created two pivot tables but when I change the parameter in one pivot table, it changes it on the other. How do i decouple them?
With regard to 2), which parameter are you changing?
If you are using e.g. a dimension group and change the dimension field in one chart, this will also affect all other charts that use the same dimension group (in other words, the current field is a property of the group, not the chart).