Skip to Content

Apply Structure in Webi Crosstab report and get the Overall result at the end.

crosstab-structure-help.jpg

Kindly help to achieve this scenario in crosstab BO 4.1. Thanks in advance to all Mentors..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Dec 18, 2016 at 09:29 PM

    try like this.

    =Sum([Measure]) where ([Dists Channel]="1"

    Add comment
    10|10000 characters needed characters exceeded

    • Amit,

      I don't want to hard Card it to get the subtotal Distribution Channel wise(1;2;3). Later Distribution Channel can have new addition of values. So this won't work. My requirement is dynamic- Distribution Wise Subtotal to get at the end, If apart from existing column value (4,5,6) is added then at the end all subtotal means 6 rows(1;2;3;4;5;6) to be displayed .

  • Dec 19, 2016 at 05:30 AM

    Amit,

    Thanks for your reply.

    My Concern is How do I apply Structure(Distribution Channel) type of restriction for each Material No in a Row. For Eg One Material number XX1 for that Distribution "1";"2";"3" must be reapeated. If no Measure is there then still it will Show with blank Record. In my case I am finding When I am applying break on Material No, Only it is showing one Distribution Channel let Say "01" . I want all 3 (Three) Distribution Channel will be shown and give the SubTotal Material Wise.

    Requiremnt:- For Every Material, Distribution Channel Should be repeated "01";"02";"03" and display the Sub Total. if no Measure value is there against that row(Material) then the cell should display null.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 19, 2016 at 09:50 AM

    Did you check the option in format table for "Show rows with empty measures"? If not try checking it and then see.

    Also I would recommend you to go to format number and assign 0 when it is equal to null or undefined.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05, 2017 at 02:01 PM

    Hi Amit ,

    We can't get the required format with 1 table . we can get the same structure using a vertical table attached to cross tab with only Distribution channel and measures .

    We should set fixed width for columns which has dimensions in the case in both tables to retain formatting ..

    Thank you

    Sateesh

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Sateesh..

      I got it what you trying to say. But I would like to see some straight forward way with some if IF ELSE logic to separate the subtotal & Row values. And apply this variable in the Break.

  • Jan 06, 2017 at 02:40 PM

    as footers are only to display aggregated value ,we dont get dimensions values extended in rows as you need . If you are sure with no of footer rows you will be needing in atleast for next 2 years , then you can go with hard coding with If else's .

    Thank you

    Add comment
    10|10000 characters needed characters exceeded