[jepi2012]

I’m wondering why it’s not possible to create a matrix report from activities.

I’d like to count the number of activities logged on a month to month bases based on type, but unfortunately the Matrix option is not available for Activity based reports.

Is there another way to do this report in NetSuite?
This is a cached copy. Click here to see the original post.

[Olivier Gagnon NC]

RE: Not possible for an activity matrix report?

You should be able to using formulas. You set up 12 formula fields (1 for each month). For formula needs to be something like

case when to_char({startdate},’MM’)=’1′ then 1 else 0 end

Replace 1 with the correct month for each column, then add a SUM grouping on each one.

Hopefully this can get you started

[Author]

Posts