Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to Combine these to set analysis expressions
1) Count( {1<Call= {Phone} >} Call )
2) Count(Total <Mon> Call )
I want each month subtotal whose call type is Phone
thanks in advance
Add the month to your first statement:
{1<Call='Phone',Mon='1'.}
Thanks for your reply... but does not solves my problem
Img1 is my chart, img 2 is how I want to populate with the month total in the totals column.. Ex: - 121 for Apr 09.....
This is Img 2
oh, instead using set analisys in this case, what about a calculated dimension like
then check this dimension´s "Suppress when field is null" Dimensions tab option. The sum expression will simple Sum(value) one.if(Type='Phone',Type,null())