sunny_talwar
MVP
2016-12-14
09:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Here is the new chart
Dimension
=Aggr(If(
rangesum(above(TOTAL (Sum({<ArticleNo>}TotalNetPrice)/Sum(TOTAL {<ArticleNo>} TotalNetPrice)),0,RowNo(Total)))<0.6,'A Stocks',if(
rangesum(above(TOTAL (Sum({<ArticleNo>}TotalNetPrice)/Sum(TOTAL {<ArticleNo>} TotalNetPrice)),0,RowNo(Total)))>0.6 and rangesum(above(TOTAL (Sum({<ArticleNo>}TotalNetPrice)/Sum(TOTAL {<ArticleNo>} TotalNetPrice)),0,RowNo(Total)))<0.9,'B Stocks',
'C Stocks'
)
), (ArticleNo, (=Sum({<ArticleNo>}TotalNetPrice), DESC)))
Expression
=Count(DISTINCT ArticleNo)
=Count(DISTINCT ArticleNo)/Count(TOTAL DISTINCT ArticleNo)
=Sum(TotalNetPrice)
=Sum(TotalNetPrice)/Sum(TOTAL TotalNetPrice)