topic Re: Block drill down or Isolate drill down? in App Development

Block drill down or Isolate drill down?

Thu, 18 Feb 2016 03:16:40 GMT

I three graphs and all data comes from the same table, I would like to use when you drill down from a chart the other are not affected.

Example:

When I select the first graph commission other graphics can not be changed.

How do I do that?

Thu, 18 Feb 2016 16:51:36 GMT

you can add {1} in the measure

e.g. SUM({1} Revenue)

but you won't be able to filter down the charts you use it on. (you could drill down the first graph and the others wouldn't change)

kaushiknsolanki — Thu, 18 Feb 2016 16:53:18 GMT

Hi,

Use the set analysis to do this.

All you have to do is, deselect the field in other chart.

For example, for 1st chart write expression as

Sum({<Product = , Customer = >}Sales)

For 2nd

Sum({<Account= , Customer = >}Sales)

For 3rd

Sum({<Product = , Acocunt= >}Sales)

Regards,

Kaushik Solanki

Thu, 18 Feb 2016 16:54:40 GMT

or look into Alternate States