Total in Straight table row wise

[#1]

Hi,

I have a straight table where i want to show Row wise Total.

In Dim i have few strings like

Dim                                  Expr(Count)

Product1 Source                    55

Product2 Source                  150

Product Target                       10

Product1 Target                      25

Product2 Target                      25

Product3 Source                     30

What i want is Just two fields in Dim and Expr as

Dim                        Total

Source                    235

Target                       60

I used set analysis though but not getting what i expect..

Thanks.

[PrashantSangle]

Hi,

Use my expression given above

Try this

=if(WildMatch([product Name],'*Source'),'Source','Target')

Regards,

[#3]

I have three category actually.(Source,Target,Excl) but i want to show only for Source and Target

[PrashantSangle]

Hi,

Then try this

=if(WildMatch([product Name],'*Source'),'Source',if(WildMatch([product Name],'*Target'),'Target'))

Regards,

[#5]

Nope max Dreamer.It's not correct.throwing error.If i use Nested If it's working fine but only showing Source and Total for all Product Source.can't see Target

[PrashantSangle]

Hi,

my bad I had just update my expression,

Regards,

[#7]

That's the one i posted above too.It's showing though but count is not correct again.Source total is correct but Target total is  taking instead Excl totals.

[PrashantSangle]

Hi,

Where you are getting wrong total??

In My attached app it works fine.

I am attaching my app check it.

It might help you.

Regards