How to create a virtual row in script

[Bhushan1]

Hi All,

I have a country and measure and placing these objects in a table. In my country column I have 3 rows (IN, US and UK), but my requirement is need to show additional row which is a combination IN+US. How to achieve this requirement with out effecting other tables like gender table. Please find the attached qvf file for your reference.

Country	Sum(measure)
IN	100
UK	300
US	200
IN+US	300
Totals	600

Note: even after adding new row (IN+US) totals should show as actual value i;e IN+UK+US=600.

Regards,

Bhushan

[tresesco]

Try using dimensionality() like:

[Bhushan1]

Hi Tresesco,

Thanks for your reply. I have tested your post, it's working with dimensionality(), but I need to add some extra further requirement to my post.

I have two filter panes, first filter panel contains set of filter and applied "firststate" alternate state to it. Second filter pane contains a set of filters and applied "SecondState" alternate state to it.

if you see in my previous attachment, I have placed Gender table also. Actually that gender table contains Gender dimension and 3 measures (All (which will not reflect to any filter from top filters),FirstStateSales measure will reflect only for "FirstState" filter pane alternate state filter and "SecondStateSales" measure will reflect only for "Secondstate" alternate state filter.

Note: this gender table should not consider newly created virtual row while calculating those 3 measures because of that i have added condition flag={0} in set analysis.

Please find the attached modified qvf and help me on this.

Regards,

Bhushan