Joined: 16 Dec 2010
Location: Peru
Online Status: Offline
Posts: 1
Topic: Grouping by Formula Posted: 16 Dec 2010 at 2:44pm
Hi, i'm using a cross-tab and grouping (in columns) with a formula
@GroupIncident if {HPD_HD.Assig_Group} = "GO BSS" then "Back Office" else if {HPD_HD.Assig_Group} = "GO NSS" then "Front Office" else if {HPD_HD.Assig_Group} = "GO AAE" then "Middle Office"
But in the results:
Total Back Office Front Office 10 4 6
I would like to print Column "Middle Office" with value "0". How do I do that? :
Total Back Office Front Office Middle Office 10 4 6 0
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum