Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I have data in straight table as below
READ | MonthYear | Enter | Gone | Ready |
Stats | Jan 2013 | 3 | 3 | |
Stats | Jan 2013 | 2 | 2 |
how to merge tow same READ rows so, I need out put as below
READ | MonthYear | Enter | Gone | Ready |
Stats | Jan 2013 | 5 | 3 | 2 |
please can anyone suggest me how to do this?
Thanks.
Hi,
take Read and MonthYear as dimension and
Write expression for
Sum(Enter) for Enter
Sum(Gone) for Gone
sum(Ready) for Ready
Regards
it sholud be already merged in a str table chart with 2 dimensions and 3 (sum) expressions
or I'm missing something?
maybe you have 2 different date on the same month in a calculated dimension formatted as MMM YYYY?
use =Date(MonthStart(datefield), 'MMM YYYY')