-
Re: Maximum across time
The TIMESUM function has MAX as one of the aggregate choices. Would that help?1 -
Re: SUMIF function
Maksim, If the colour list was Red, Yellow and Blue, then how about a summary module with three line items, with Product_List as a dimension, and three formulae: IF Product_List.Colour = Colour.Red T…1 -
Re: Unique Count in Summary
Count1 is my first module, with Products and Reps lists, and one Line Item (Sell). Count2 is my second, with only the Reps lists and one Line Item (Count).1 -
Re: Module Line item is text and want to feed it to a list, formatted as list
Carolyn If your States list follows the International Organization for Standardization (ISO) coding ISO 3166-2, then they will take the form "US-zz". However, you should be able to use the …1 -
Re: TIMESUM over quarters
Sorry Diana I was using the month start format i.e. jan 15 as opposed to Q1. Thanks for your help.1

