求救
Microsoft 365版本
我而家有以下既excel data
Column A; Column B; Column C; Column D-O; Column P
Product; sales channel; Indicator; January - December; Total
Apple; supermarket; Quantity; 一月至12月既銷量; 成個row既total
Apple; supermarket; Revenue; 一月至12月既revenue; 成個row既total
Apple; supermarket; Cost; 一月至12月既買貨成本; 成個row既total
Apple; online; Quantity; 一月至12月既銷量; 成個row既total
Apple; online; Revenue; 一月至12月既revenue; 成個row既total
Apple; online; Cost; 一月至12月既買貨成本; 成個row既total
Apple; total channel; Quantity; 一月至12月既銷量; 成個row既total
Apple; total channel; Revenue; 一月至12月既revenue; 成個row既total
Apple; total channel; Cost; 一月至12月既買貨成本; 成個row既total
假設我有成千種類既貨物係以下既row
而最後三個row分別係1月至12月既所有產品在所有channel既total quantity, total revenue and total cost
而家想整一個pivot chart (折線圖), 想show x axis係1-12月, y axis係quantity, 然後想filter某一個產品(例如apple既quantity同埋total所有產品既quantity整成兩條折線, 應該點樣set pivot table fields果4個格仔
試極都唔岩