sharepoint - DASHBOARD creation in MOSS 2007 using DVWP and XSL -

my earlier post pasting on here between lines;

for creation of dashboard need find out way count of items in field of list. how same in real time?

let’s have list following fields;

quarter >>>> batch# >>>>>> in field/packed/shipped

for eg, if entries first list given below;

quarter >>>>>>>>>>>>>>>>> batch# >>>>>>>>>>>>>>>>>>>>> status

q1 ------------------------------------b1------------------------------------ in field

q1 ------------------------------------b2 ------------------------------------in field

q1------------------------------------b1 ------------------------------------packed

q1------------------------------------b2 ----------------------------------- shipped

q1------------------------------------b2------------------------------------ shipped

now, need dashboard list in give below result;

it should like;

status >>>>>>>>>>>>>>>>> batch 1 >>>>>>>>>>>>>>>>> batch 2

in field ------------------------1----------------------------------1

packed ------------------------- 1-----------------------------------0

shipped------------------------- 0----------------------------------2

please upon how create dashboard above.

as per ryan suggested tried creating dwvp webpart xsl coding create dashboard. have emcoundered problem.

first created list in have,

status >>>>>>>>>>>>>>>>> batch 1 >>>>>>>>>>>>>>>>> batch 2 , list fields

in field ---------------x1--------------------------y1

packed -------------------- x2--------------------------y2

shipped-------------------- x3--------------------------y3

here trying inser ta formula x1, x2 , x3 unique per each item in row "status"

but give formula x1, same applied entire colum ie x2 , x3 :( there way create specific formula x2 , x3 .. y1, y2, y3 repectively.

kindly help

regards, jiben.

i don't think can provide different formula each row processed. can in situation build formula can provide result want based on values of row.