Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends,
I have a senario, i am attaching a sample. I have a listbox name 'status'. As of now i have to show count of each status.
for eg: open,closed,...now in expression i m giving hardcode expression like :
Count({<status={'open'}>}status)
Count({<status={'closed'}>}status)
later another status may get added like., inprogress....instead of status...i need dynamicaly...so that
automaticaly it should get added.
can u plz help on this
add both dimensions "dim,Status " as dimension and write your normal expression as follows
Count(status)
add both dimensions "dim,Status " as dimension and write your normal expression as follows
Count(status)
Hi,
If you need you need to show this in a list box just check "Show Frequency" flag in the list box setting.
If you mean a chart I'd use 'status' as dimension and 'Count(status)' as an expression.
Best regards,
Maxim
your ans helped me..thankx...small thing is when i use it in pivot and drag...i dont need the dim name...
i have attached a screen short !
go to Properties>Dimension and select status >> in the label press space
Hi,
Please find the application attached