Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Use my expression given above
Try this
=if(WildMatch([product Name],'*Source'),'Source','Target')
Regards,
I have three category actually.(Source,Target,Excl) but i want to show only for Source and Target
Hi,
Then try this
=if(WildMatch([product Name],'*Source'),'Source',if(WildMatch([product Name],'*Target'),'Target'))
Regards,
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
Hi,
my bad I had just update my expression,
Regards,
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.
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