How can we show one of the page filter in the very first cell of a pivot table.
* Here I am attaching a file, In the attached file you can see a highlighted page filter "An_Category" which i want to display it over the first cell which is highlighted with red line.
If you can do it in a Dashboard, then you can put the page item as a row item... and synchronize with a related selector in the dashboard.
I can't think of any way to do this in a module because the item is either a page item or a row item, but cannot be both.
Thank you so much Paul.
As @PaulRitner says, this is exactly why we advocate using dashboards for end users; they allow a lot more functionality over modules