Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I would like to ask you about chart and table,
I have qvw doc and there is any table for show the sum of company_pay.
Usually, if i choose / click one company_pay, then in the table only appear one company. like below :
But, I wanna show the detail of company_pay without sum if i click one of company_pay. like below :
Is it possible to do this?
I enclode the qvw doc in attachment.
thanks and regards,
Ted
may be like this?
Hi K N,
thank you for your replay,
but i would like to click company_pay not currency. and if i click one of company_pay, it will show detail of company pay in detail table and the main table is hidden.
Hi Ted,
the reason as i am sure you know id that the straight table does not have a unique combination in the dimensions to break it down.
in order to do it as you would like, you can simply add more dimensions to make each row unique (namely your "Curren" field) and then in the presentations tab use the "Hide Column" function
Hi gareth,
thank you,
if i use your way, it will show all the detail without click the company_pay.
not a problem.
in the dimensions tab. select "curren" and check the enable condition. in there type:
GetPossibleCount(company_pay)=1
this will show the details when there is only 1 possible company_pay value