excel formula required

[shahzad_143]

aslam o alikum

dosto mujay formula lagany ka method chahiya main aik sheet bnata hun is may
daily sale ka record ho or suppose 1o product sale hote hayn aub month end per main agar specific product ke monthly sale dekhna chahun to kysy dekh sakta hun filter ka method mujy pata hy mugar us main total nhe aata plz help

[shahzad_143]

ya pic ko dekh kr ap ko idea ho jay ga k main kon sa formula chah raha hun plz help

[denzees]

Brother

Aap Excel main apni is problem ko "Pivot Table" ki options se bohat aram se hal kar saktey hain.
Follow these steps.

1-Aap apni sheet main un tmam columns or rows ko SELECT kar lain jin se result lena hey.

2- Us ke bad DATA->"PivotTable&PivotCharReport"-> par click karain.

3- Jo Wizard open ho us par bas "Finish" par click kar dain.

4- Aik nai sheet open ho ge jis main aap ko aik window main apne tama columns ki headings nazar ayen gi.

5- main Headings ko oper "Headers" main le jain.

6- Jin se result chahiye un ko neche rows main le ain.

Hope aap ko samaj aa gai ho ge. Agar problem hey to mujhe wo sheet behj dain main solve kar ke wapas behj don ga.

Reagards.