I have a SSRS (2008 R2) report on an Olap data source. On rows I have Agents (as a row group), on columns I have Stores
(as a column group) and a measure, let's say SeelOutValue. I want to see sales from agents to stores.
I added a page break between each group instance on the Agent row group => one page for an Agent, but the column stores
are not filtered by the Agent. I want to see on an Agent page only the stores with values.
My question: can I filter the columns (Stores column group) for each Agent (row group)?
Store1 Store2 Store3 Store4 Store5
Agent2 2 2
Agent 3 ....
Now an each Agent page there are all 5 stores columns (on Agent1 page column Store2 and Store4 without data).
It is possible to see on Agent1 page only Store1, Store3
and Store5 columns,
on Agent2 page Store1 and Store2 columns ... ?
Thanks in advance for your help!
View Complete Post