Tracking Daily, Weekly and YTD sales in Excel PivotTable

-

i've been tracking company's daily sales years in manually formatted excel table, introduced pivottables. part seem great, i'm having trouble setting pivottable track daily, weekly, , ytd sales. i've managed setup pivottable show daily sales in columns (mon., tues., wed., etc...) , automatic total column adds daily sales arrive @ sales week. now, have 1 more column tacked onto end of chart shows ytd sales each price point.

advice welcome. please let me know if can supply more info on i'm looking for. trying concise possible.

i've pasted example of raw data , ideal pivottable below.

thanks!


raw data sample:

w/e date day description # tix $ tix
9/30/2007 9/24/2007 monday full price 100 $1000
9/30/2007 9/24/2007 monday premium 200 $4000
9/30/2007 9/25/2007 tuesday full price 150 $1500
10/7/2007 10/1/2007 monday full price 200 $2000


ideal pivottable:

10/7/2007

monday tuesday wednesday total week total ytd
full price
premium
total total total total total
 



Forums Macs Mac Apps and Mac App Store


  • iPhone
  • Mac OS & System Software
  • iPad
  • Apple Watch
  • Notebooks
  • iTunes
  • Apple ID
  • iCloud
  • Desktop Computers
  • Apple Music
  • Professional Applications
  • iPod
  • iWork
  • Apple TV
  • iLife
  • Wireless

Comments

Post a Comment

Popular posts from this blog

Currys UK online order nightmare!

-
Image
i'm disappointed in currys' online service. ordered 16gb touch, once had received confirmation email realised address had wrong house number. tried call them, , bounced around 5 different phone numbers (some repeated, different instructions!) , turned out best advice give me cancel order, , order again change house number! how outrageous. anyway, cancelled order , didnt bother ordering again. time i'm going official apple store. it'll take few more days deliver, better discount voucher. oh, know lazy , myself, apple store's refund policy, if find touch not me can return within 28 days, if isnt defective? because i'd rather have classic?   oh dear god... thought had cancelled it. turns out happened call again due lack of confirmation on cancellation, , said not possible me cancel order had apparently been dispatched already. summing up, have wait ipod (whi...
Read more

Mini-DVI to DVI-I?

-
Image
i looking around @ best buy , found little bugger. http://www.dynexproducts.com/pc-584-9-dynex-mini-dvi-to-dvi-adapter.aspx yep, that's dvi-i. should able use dvi vga , dvi hdmi adapter on sucker. no need cough money both apple adapters. should able test dvi vga @ least next week.   attached files: a"> dynex.jpg file size: 56.1 kb views: 1,351 the dvi vga adapter never ended working in end. detected there monitor never displayed anything. promptly returned best buy.   Forums Macs Notebooks MacBook Pro iPhone Mac OS & System Software iPad Apple Watch Notebooks iTunes...
Read more

New iMac here - LOVING the Mighty Mouse

-
Image
i have mbp, , talked wife getting imac after dell (she loathed machine, made sell easy) crapped bed. when deciding on bluetooth mouse mbp, passed on mighty mouse wireles becasue of review here seemed negative. ordered corded version imac came friday. long story short, have been using mm , found quite enjoyable! in fact prefer logitech v220 im using now. found out have tendency lift left finger off botton when using normal 2 button mouse. made use of mm natural me. absolute best part of mm freaking scroll ball. orgasmic use!! l o v e mechanical smoothness , feel of ball in motion. using app steermouse able fine tune puppy perfect. on fence mm, let me assure pretty awesome, , person ultra picky point of ocd mice.   good review! imac prepared shipping, should coming in few days. i'm going using standard wired mm comes it, positive feedback on it. worried going horrible,...
Read more