I need to create a LINE CHART in the following way:
X dimension: MR_DATE (i.e. month+year)
2° dimension (different lines): CATEGORY (I need to split my measure by the different categories)
Measure: Count( ITEM ) / sum( IB )
My problem is the following: while for the Count( ITEM ) is necessary to have different values according the different CATEGORY values, I need that sum ( IB ) is independent from the CATEGORY dimension (i.e. for all the CATEGORY values the sum( IB ) lines has to be all equal to each other).
What I need (all sum (IB) lines overlapped - no changes from different CATEGORY value):
What I currently get:
I'm supposing this depends from the fact that for some CATEGORY values, some component of the IB are not existing (for example the sum (IB) is summing the IB from different countries and if for a specific CATEGORY and MR_DATE a country is missing, I'm losing it's contribution to the total IB).
Currently, since the sum ( IB ) should be influenced only by the following fields: MR_DATE and COUNTRY, I'm using the following formula:
I was trying to ignore all the selections but COUNTRY and MR_DATE with the aim to ignore also CATEGORY... however it doesn't work => the lines in the graph are different according to the specific CATEGORY...
How can I ignore, only for the sum( IB ) the split between the different CATEGORIES, keeping it for the count( ITEM) ?