Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
please help?
hi ,
i want to add field of two diifferent list boxes in to one list box and want to use it as a dimension
Could you please help ?
It depends on data model (how the fields are associated). Try to share your sample qvw.
both list boxes are having similiar type of fields but one list box is having data of mech dep and another one is having data of electrical dep.
so basically i want to show revenue of two dep on A SINGLE GRAPH . THE FIELD I WANT TO COMBINE IS Department SO DAT MY GRAPH DIMENSION WILL SHOW electrical and mechanical sep.
Again, it's hard to answer without knowing your model. Theoritically can be told that, you could think of CONCATENATEing the table.
Hi,
If the fields are associated,you can use expression in List Box instead of Field Name. (eg: =Field1 &'-'& Field2).
If your data model is perfect then in the dimension you can use
=Field1&'_'&Field2 same you can use in any list box try to plot any list box and in expression write two fields with concate words like &'_'&