Ungakushintsha Kanjani Ukunikezwa Kolwazi Lwedeski Le-Pivot futhi Uyahluka

Isibuyekezo sokugcina: 04/10/2024

Ngokuncika ohlotsheni loshintsho olungaphakathi Kolwazi Lokuhlinzeka olusetshenziselwa Ideski Le-Pivot, ungase uthole isidingo sakho kokubili Ukushintsha Ukunikezwa Kolwazi Lwedeski Le-Pivot noma uvele Ushintshe I-Pivot Desk Vary.

Shintsha Umthombo Wedatha Yethebula Le-Pivot Nobubanzi

Shintsha Ukunikezwa Kolwazi Lwedeski Le-Pivot futhi Uyahluka

Ngokuvamile, akuvamile ukuthi kwengezwe Imigqa eyengeziwe ngaphakathi Kolwazi Lokunikezwayo ukuze kufakwe idatha entsha noma okufakiwe.

Ngokulinganayo, ungase futhi uthole isidingo sokuhlela kabusha ngokuphelele Ulwazi Lokunikeza Ngokufaka Imigqa Yolwazi emisha namakholomu Olwazi Olusha.

Uma lokhu kwenzeka, kuzodingeka ushintshe Ulwazi Lwedeski Le-Pivot ukuze ufake amakholomu nemigqa esanda kungezwa ngaphakathi Kolwazi Lokunikezwayo.

Nokho, uma Ulwazi Lokuhlinzekwa Kwempahla lufika kwiphepha lomsebenzi elisha sha, uzothola isidingo sokushintsha ukuhlinzekwa Kolwazi Lwedeski Le-Pivot lisuke kwesiphelelwe yisikhathi libe Isipredishithi Esisha.

1. Shintsha Ulwazi Lwedeski Le-Pivot Iyahlukahluka

Noma nini lapho Imigqa emisha noma Amakholomu engezwa kokuthi Supply Knowledge, ungakwazi ukubona izinyathelo ezingezansi Zokushintsha Ukuhlukahluka Kolwazi Lwedeski Le-Pivot.

1. Chofoza kunoma yikuphi Iseli ngaphakathi kwedeski le-Pivot futhi lokhu kungase kunikeze Amathebhu okuthi “Hlaziya” kanye “Nokwakheka” ngaphakathi kwebha yemenyu eyinhloko.

2. Okulandelayo, chofoza ku- Hlaziya ithebhu> Shintsha Ukunikezwa Kolwazi > Shintsha Ukunikezwa Kolwazi... kungenzeka ngaphakathi kwemenyu yokudonsela phansi.

Shintsha Idatha Yomthombo Wethebula Le-Pivot

3. Kunkambu yengxoxo ye-Pivot Desk Knowledge Supply ebonakala sengathi, chofoza ku- Ideski/Iyahluka bese ukhetha Ukuhluka Kolwazi lonke (kanye nemigqa namakholomu amasha) ofisa ukukuhlanganisa.

Shintsha Ububanzi Bedatha Yethebula Le-Pivot

3. Chofoza ku- OK ukuze wonge izinguquko eziningi.

2. Shintsha I-Pivot Desk Knowledge Supply Worksheet

Uma Ulwazi Lokunikezwa Kwedeski Le-Pivot selufikile ekhasini lokusebenza elisha sha, ungakwazi ukubuka izinyathelo ezingezansi zokushintsha Ukunikezwa Kolwazi Lwedeskithophu ye-Pivot.

1. Chofoza kunoma yikuphi Iseli ngaphakathi kwedeski le-Pivot futhi lokhu kungase kunikeze amathebhu "Design" kanye "nokuhlaziya" ngaphakathi kwebha yemenyu eyinhloko.

  Ungayisebenzisa kanjani i-WPS Office ukuhlela amafayela ku-FileCloud

2. Chofoza ku- Hlaziya > Shintsha Ukunikezwa Kolwazi > Shintsha Ukunikezwa Kolwazi kungenzeka ngaphakathi kwemenyu yokudonsela phansi.

Shintsha Idatha Yomthombo Wethebula Le-Pivot

3. Kunkundla yengxoxo ye-Pivot Desk Knowledge Supply, chofoza u-in Ideski/Iyahluka bese ucindezela inkinobho Ishidi Lokusebenzela equkethe Ulwazi Olusha Lokunikezwayo.

Shintsha Umthombo Wedatha Yethebula Le-Pivot ube Ishidi Lokusebenzela Elisha

Njengoba ungase ubone esithombeni esingenhla, indawo ethi “Desk/Vary” ibhekisela ekhasini lokusebenza elithi “Gross sales Jan” bese uchofoza okuthi “Isamba sokuthengisa Feb” kuzoshintsha Ukunikezwa Kolwazi Lwedeskithophu Le-Pivot kube ishidi lokusebenza elisha sha.

Ngemva kokushintsha Ukunikezwa Kolwazi, qiniseka ukuthi Ulwazi Oluhlukile luqukethe yonke imigqa namakholomu okufanele afakwe ngaphakathi kweDeski Le-Pivot.

4. Chofoza ku- OK ukuze wonge izinguquko eziningi.

  • Ungangeza kanjani noma ususe kanjani ama-subtotals ku-Pivot Desk
  • Ungazimboza Kanjani Izikhala Edeskini Le-Pivot