Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Having trouble getting time period specific share calculations to work correctly. 2 dimensions (product and month). Assume 3 months and 2 products selected. LIne chart will show monthly sales for each product for each month (6 data points). Need expression that will convert each product/month sales to a percentage of all product's sales for the month.
Tried variation of set analysis, total qualifier, and AGGR function but cannot get to work.
Issue resolved. Object built with time cycle group as dimension. use of AGGR function worked once appropriate dimension variable name was used.