Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
My objective is to display in a bar chart the total extended amount per 'CO_CD' dimension. However I want to exclude certain data found in thw 'CO_CD' dimension and thus not include it the total calculation)
I was able to create a straight table which includes the companys (CO_CD) I want to factor in my bar chart.
I have excluded the company (CO_CD) by building the expression on the 'CO_CD' dimension
(NOT WILDMatch(CO_CD,trim('ANZ*'),trim('BancoBilbao*') etc ( see expression on example
From the straight table I want to be able to create another Bar chart showing the Total extended amount by CO_CD
When I add an additional expression i.e sum( extended mount), my bar chart keeps including 'CO_CD' I want to exclude as per the expression I have built.
Your assistance would be much appreciated
Regards
Rohan
Maybe using set analysis expression to exclude dimensions can solve this.
Something like SUM(${<CO_CD=>}, Sales);
Thanks Jao
I go round this by computing this expression on the dimenions tab as opposed ot the expression tab
Then on the expression tab did a simple sum (extended amount)
Thanks for your suggestion though
Also to build complex expression analysis this wizard can be helps you