Skip to Content
0
Former Member
Apr 03, 2008 at 11:07 AM

Counting

9 Views

hi

we need to create a summary of the report.

in the existing report user gets top N articles say top 300 articles with their stock. hence data for each plant is show 300 rows.

now user want to summarise the data.

say

for site A, out of top 100 articles 20 has stock <=0.

for site B, out of top 100 articles 50 has stock <=0.

etc

report to show:

Site No of Articles withstock <= 0 %stock out

A 20 20%

B 50 50%

how to count no of articles as it varies with user input date and top N?

regrds: gaurave