Need To Do A Rollup Sum For Certain Rows and Sum All Others

[pnn44794]

Hello:

First, I believe I'm making this harder than it needs to be and my apologies for the length of the post.           But I've been looking at it too long and I would appreciate another set of eyes taking a look.  I currently have the following output from this expression:

Expression:

[duncanblaine · Accepted solution]

Hi Perry
Some possible solutions could be to

• create a new column in your XLS which identifies the parent grouping
• create a mapping table in your load script that effectively does the above, but in script
• or possibly the easier is to use Calculated Dimension in your chart eg.
  
  

=IF(Wildmatch(ProductField,'NAS*'),'NAS (GB)',

IF(Wildmatch(ProductField,'SAN*'),'SAN (GB)',

ProductField)

Hope that helps
Duncan

[pnn44794]

Hello Duncan:

Sorry for the delay in replying.  Thank you for your response.  Your suggestion of using Wildmatch did the trick.  Thank you very much for that.  Turns out I needed to roll up a couple more items.

Thanks again.  I'll mark your response as the correct answer.