Display one row item

[#1]

I have a table that displays the same item for different months. I want only one row item to be displayed summing up each of the months value. But when i use the month filter pane it should just give me the selected months value.

example: name impressions clicks ln market period

               495 trade  230       16        03/12

               495 trade   130      12        04/13- 04/30

               495 trade   140     5           05/23

I want just one row item to be displayed in my table that is 495 trade and the sum of the months. and later when i select the filter pane lets say march it should return 495 trade 230 16 03/12

How can this be achieved?

Thanks

[vishsaggi]

When you say sum of months? You mean what sum? impressions sum or Clicks sum?

Try like

Using straight table

Add dimensions: name

                            ln market period -> For this dimensions check enable conditional and write the condition like

                                                                 = GetSelectionCount(lnmarketPeriod) > 0

Expr1: Sum(impressions)

Expr2: Sum(clicks)

[dinuwanbr]

Hi Tiwari,

Can you upload a sample for better understanding?

Rgds,

Tharindu