11 Replies Latest reply on Sep 18, 2017 4:20 PM by Jennifer VonHagel

# Multiple dimensions to a single filter option

I have four standalone reports which uses same view from DB.

I'm trying to calculate the payment analysis based on four categories (0-30),(31-60),(61-90) & Over 90. But I have four different fields (four different reports) which has these four categories in it.

Ex: Consider A(dimension) which has 0-30, 31-60, 61-90 & Over 90

B(Dimension) which has 0-30, 31-60, 61-90 & Over 90. In the same way for dimension C, and Dimension D.

Instead of developing four different reports for these four dimensions. I'm planning to develop a single report where I could have a filter for A,B,C,D dimensions. Is there any way where I could combine these four dimensions into a single parameter and use this in column field and also add this parameter as a filter. SO, I could select the dimension required from the filter. When I select A it would reflect the payment analysis for the four categories above and the same with the rest of the dimensions.

• ###### 1. Re: Multiple dimensions to a single filter option

Hi Anjal, I think we need to see how your data is structured.

But if it is as simple as something like this, then you can create a dimension swapper.  The table just shows the structure of the data. And I have created a parameter and formula linked to it showing in the screenshot.

Now we can remove all the Report A, B, C, D dimensions, and just put the calculated Report Dimension here. When we select a report from the parameter, our table will give us that report's numbers:

If this doesn't help, send a sample of data .

Best,

Jennifer

• ###### 2. Re: Multiple dimensions to a single filter option

Jennifer,

Thanks for your response. In my case I want to see Report A, B,C,D in the filter option. So, here when I select report A in filter I should be able to see data for A, and vice-versa

• ###### 3. Re: Multiple dimensions to a single filter option

The second screenshot doesn't show what you want? Is it that you don't want the parameter?

Thanks,

Jennifer

• ###### 4. Re: Multiple dimensions to a single filter option

Jennifer it's working but in the choose report field I cannot find A,B,C,D. I'm not getting any filter option. Could you attach the workbook please. Thanks

• ###### 5. Re: Multiple dimensions to a single filter option

Oh of course. .twbx Attached.

For Choose Report, manually create a Parameter:

And type the List of values in:

• ###### 6. Re: Multiple dimensions to a single filter option

Jennifer, Thank you. It's working .

• ###### 7. Re: Multiple dimensions to a single filter option

Sure thing, happy to help.

• ###### 8. Re: Multiple dimensions to a single filter option

Jennifer,

For the same set of these four category ranges, 0-30 and etc I have an other Dimension E. But I do not want that to be included in the filters above. I have negative values and positive values for this dimension. What would the best form of representation would be good with positive and negative values. Thanks

• ###### 9. Re: Multiple dimensions to a single filter option

Hmm, I think some sort of bar chart would be good, there are a few options in the workbook I attached (I used Report D as an example and created some negative numbers).  If you have questions on any of them let me know.

Best,

Jennifer

• ###### 10. Re: Multiple dimensions to a single filter option

Could you upload a picture of it. Im using 10.1 version so I'm not able to open the workbook

• ###### 11. Re: Multiple dimensions to a single filter option

Sure. I have three types, all pretty simple. I'll screenshot the whole view so you can which fields go where.

Vertical Bar, no special color, compares a second dimension (months in this case) within each Report value.

Horizontal Bars, Colored by volume, compares each Report value within a second dimension.

Stacked Horizontal Bar (not sure this is the best option for comparing 0-30, 31-60, etc. across multiple dimensions, but it's kind of nice to see the span of values all in one bar, and gives a quick sense of total negative vs positive values among the whole)

If you click on the legend, you can highlight a value to more easily see its trend:

If you need further detail, let me know.

Best,

Jennifer