2 Replies Latest reply: Oct 9, 2012 9:28 PM by Fei Xu RSS

    Suppress one column in table and exclude its value from another column

    Fei Xu
      Hello,
      Can anyone help with below thing for me please?
      My real project is very complicated. Image one branch has sold some product, so this branch and its benchmark group have some feagure while another branch in the same benchmark group has not sold that product. When we calculate the average sold product per branch for the benchmark goup, we should use total sold value divided by one branch, rather than two branches, shouldn't we?
      Please see attached sample. Thanks a lot!
      1) Dimension is Cycle group.

      2) Must select a Branch. Then first expression shows the data for that branch and seconde expression shows the data for the Benchmark Group that the selected branch belongs to.

      3) When the branch data is null but benchmark Group data is not null, that row cannot be suppressed automatically.

      4) What I want is to suppress the rows with null value for Branch and also in the total number for Benchmarg Group, exclude the value for the branch that have been suppressed.
      TransIDBranchBenchmark Group
      Total118.9123.7
      37.0 5.6
      48.55.5
      56.6
      66.57.7
      74.54.4
      83.3
      98.52.2
      105.58.8
      119.9
      124.4
      134.45.8