Count layout

[dhanu_today]

     Hi All,

    I have the data in my table as a result of an expression.How we can get the below bolded format in design level.

    Segement(DIM1)        Sub-seg(DIM2)          Exp1              >=50000 and <=100000           >100000  and <=150000

     TC                              TC-Azc                   90000                1                                            -
     TC                              TC-Apc                  150000                -                                           1

     TC                              TC-BCP                 100000               1                                            -

     TC                              TC-BCL                 150000               -                                              1

                                                               Total :490000         2                                             2

    The Sub-seg field is not required in table level as a dimension.So then

Segement(DIM1)          Exp1              >=50000 and <=100000           >100000  and <=150000 

     TC                          490000               2                                           2
                                                               

  Thanks in advance,

   Dhanu

[senpradip007]

Hi.

As you dont want to show Sub-seg(DIM2), go to presentation tab and choose the Hide Column and for the next two expressions in Presentation tab select respecpective expressions and write in Column Label

>=50000 and <=100000 and >100000  and <=150000 respectively.

[dhanu_today]

Thanks Pradip.But not working...

[senpradip007]

Can you post a sample application?

[veidlburkhard]

Hi dhanu,

only one question. Are you using a pivot table or a straight table?

Burkhard

[#6]

Dhanu

write in expression - Label as

='>=50000 and <=100000'     and

='>100000  and <=150000'

Lalit

[dhanu_today]

Burkhard-Am using Pivot table.

[veidlburkhard]

OK dhanu,

then there is a simple solution.

Don't mark the 'Always Fully Expanded' check box in the 'Presentation' tab and collapse Sub-seg(DIM2) dimension.

That's all.

Hope this helps

Burkhard

[dhanu_today]

Thanks Burkhard...But still no luck...

Dhanu

[veidlburkhard]

Then, dhanu, you should attach your qvw ... otherwise no chance.

Burkhard