Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Hi Tiwari,
Can you upload a sample for better understanding?
Rgds,
Tharindu