{"id":478446,"date":"2023-08-09T09:32:56","date_gmt":"2023-08-09T09:32:56","guid":{"rendered":""},"modified":"2023-09-05T11:16:47","modified_gmt":"2023-09-05T11:16:47","slug":"pivot-table","status":"publish","type":"wiki","link":"https:\/\/oneproxy.pro\/ir\/wiki\/pivot-table\/","title":{"rendered":"\u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc"},"content":{"rendered":"<p>\u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u06cc\u06a9 \u0627\u0628\u0632\u0627\u0631 \u067e\u0631\u062f\u0627\u0632\u0634 \u062f\u0627\u062f\u0647 \u0642\u062f\u0631\u062a\u0645\u0646\u062f \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631 \u0635\u0641\u062d\u0647\u200c\u06af\u0633\u062a\u0631\u062f\u0647 \u0648 \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u062e\u0644\u0627\u0635\u0647\u200c\u0633\u0627\u0632\u06cc\u060c \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0648 \u0627\u0631\u0627\u0626\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0628\u0647 \u0634\u06cc\u0648\u0647\u200c\u0627\u06cc \u0633\u0627\u062e\u062a\u0627\u0631\u06cc\u0627\u0641\u062a\u0647 \u0648 \u06a9\u0627\u0631\u0628\u0631\u067e\u0633\u0646\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06cc\u0646 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc \u062f\u0647\u062f \u062a\u0627 \u0628\u0627 \u062a\u0646\u0638\u06cc\u0645 \u0645\u062c\u062f\u062f \u0648 \u062e\u0644\u0627\u0635\u0647 \u06a9\u0631\u062f\u0646 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u0647 \u0631\u0648\u0634\u06cc \u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631 \u0648 \u067e\u0648\u06cc\u0627\u060c \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062e\u0627\u0645 \u0631\u0627 \u0628\u0647 \u0628\u06cc\u0646\u0634 \u0647\u0627\u06cc \u0639\u0645\u0644\u06cc \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0646\u0646\u062f.<\/p>\n<h2>\u062a\u0627\u0631\u06cc\u062e\u0686\u0647 \u067e\u06cc\u062f\u0627\u06cc\u0634 \u062c\u062f\u0648\u0644 Pivot \u0648 \u0627\u0648\u0644\u06cc\u0646 \u0630\u06a9\u0631 \u0622\u0646.<\/h2>\n<p>\u0645\u0641\u0647\u0648\u0645 \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u062f\u0631 \u062f\u0647\u0647 1970 \u062f\u0631 \u0632\u0645\u06cc\u0646\u0647 \u0647\u0648\u0634 \u062a\u062c\u0627\u0631\u06cc \u0627\u06cc\u062c\u0627\u062f \u0634\u062f. \u0627\u0634\u0627\u0631\u0647 \u0627\u0648\u0644\u06cc\u0647 \u0628\u0647 \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0647 \u06cc\u06a9 \u0645\u0642\u0627\u0644\u0647 \u062a\u062d\u0642\u06cc\u0642\u0627\u062a\u06cc \u0628\u0627 \u0639\u0646\u0648\u0627\u0646 &quot;\u062f\u0631 \u0645\u0648\u0631\u062f \u062a\u062c\u0633\u0645 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0686\u0646\u062f \u0628\u0639\u062f\u06cc&quot; \u062a\u0648\u0633\u0637 \u062c\u06cc. \u0645\u06a9\u0631 \u0648 \u0627\u0686. \u0644\u0627\u0646\u062f\u0648 \u062f\u0631 \u0633\u0627\u0644 1977 \u0631\u062f\u06cc\u0627\u0628\u06cc \u06a9\u0631\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c \u062a\u0627 \u062f\u0647\u0647 1990 \u0628\u0648\u062f \u06a9\u0647 \u0622\u0646\u0647\u0627 \u0645\u062d\u0628\u0648\u0628\u06cc\u062a \u06af\u0633\u062a\u0631\u062f\u0647 \u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646\u062f. \u0628\u0627 \u0638\u0647\u0648\u0631 \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631 \u0635\u0641\u062d\u0647\u200c\u06af\u0633\u062a\u0631\u062f\u0647 \u0645\u0627\u0646\u0646\u062f \u0645\u0627\u06cc\u06a9\u0631\u0648\u0633\u0627\u0641\u062a \u0627\u06a9\u0633\u0644\u060c \u06a9\u0647 \u062f\u0627\u0631\u0627\u06cc \u0639\u0645\u0644\u06a9\u0631\u062f \u062f\u0627\u062e\u0644\u06cc \u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0628\u0648\u062f.<\/p>\n<h2>\u0627\u0637\u0644\u0627\u0639\u0627\u062a \u062f\u0642\u06cc\u0642 \u062f\u0631 \u0645\u0648\u0631\u062f \u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc. \u06af\u0633\u062a\u0631\u0634 \u0645\u0628\u062d\u062b Pivot table.<\/h2>\n<p>\u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0627\u0633\u0627\u0633\u0627\u064b \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0631\u0627 \u0642\u0627\u062f\u0631 \u0645\u06cc \u0633\u0627\u0632\u062f \u062a\u0627 \u0628\u062f\u0648\u0646 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u06cc\u0627 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647\u060c \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0686\u0646\u062f \u0628\u0639\u062f\u06cc \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u0646\u062f. \u0627\u06cc\u0646 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc \u062f\u0647\u062f \u062a\u0627 \u0628\u0627 \u062a\u0633\u0647\u06cc\u0644 \u0627\u0642\u062f\u0627\u0645\u0627\u062a \u0632\u06cc\u0631\u060c \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062e\u0627\u0645 \u0631\u0627 \u0628\u0647 \u0628\u06cc\u0646\u0634 \u0647\u0627\u06cc \u0645\u0639\u0646\u06cc \u062f\u0627\u0631 \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0646\u0646\u062f:<\/p>\n<ol>\n<li>\n<p><strong>\u062e\u0644\u0627\u0635\u0647 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627:<\/strong> \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647 \u0633\u0631\u0639\u062a \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0628\u0632\u0631\u06af \u0631\u0627 \u0628\u0627 \u0627\u0646\u062c\u0627\u0645 \u062a\u0648\u0627\u0628\u0639 \u0645\u062e\u062a\u0644\u0641 \u0645\u0627\u0646\u0646\u062f \u0645\u062c\u0645\u0648\u0639\u060c \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646\u060c \u0634\u0645\u0627\u0631\u0634 \u0648 \u063a\u06cc\u0631\u0647 \u0628\u0631 \u0631\u0648\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u0634\u062f\u0647 \u062e\u0644\u0627\u0635\u0647 \u06a9\u0646\u0646\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u0633\u0627\u0632\u0645\u0627\u0646\u062f\u0647\u06cc \u0645\u062c\u062f\u062f \u062f\u0627\u062f\u0647 \u0647\u0627:<\/strong> \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0631\u062f\u06cc\u0641\u200c\u0647\u0627 \u0648 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u06a9\u0627\u0648\u0634 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0632 \u0632\u0648\u0627\u06cc\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0648 \u0633\u0644\u0633\u0644\u0647\u200c\u0645\u0631\u0627\u062a\u0628 \u0645\u0631\u062a\u0628 \u06a9\u0646\u0646\u062f \u0648 \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u0631\u0648\u0646\u062f\u0647\u0627 \u0648 \u0627\u0644\u06af\u0648\u0647\u0627 \u0631\u0627 \u0622\u0633\u0627\u0646\u200c\u062a\u0631 \u06a9\u0646\u0646\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u0641\u06cc\u0644\u062a\u0631 \u06a9\u0631\u062f\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627:<\/strong> \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0642\u0627\u0628\u0644\u06cc\u062a \u0641\u06cc\u0644\u062a\u0631 \u06a9\u0631\u062f\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0645\u0639\u06cc\u0627\u0631\u0647\u0627\u06cc \u062e\u0627\u0635 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f \u0648 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u0628\u0631 \u0631\u0648\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u0631\u0628\u0648\u0637\u0647 \u062a\u0645\u0631\u06a9\u0632 \u06a9\u0646\u0646\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u06af\u0631\u0648\u0647 \u0628\u0646\u062f\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627:<\/strong> \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u062f\u0633\u062a\u0647 \u0647\u0627\u060c \u062a\u0627\u0631\u06cc\u062e \u0647\u0627 \u06cc\u0627 \u0639\u0648\u0627\u0645\u0644 \u062f\u06cc\u06af\u0631 \u06af\u0631\u0648\u0647 \u0628\u0646\u062f\u06cc \u06a9\u0646\u0646\u062f \u0648 \u062f\u0631\u06a9 \u0631\u0648\u0627\u0628\u0637 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0633\u0627\u062f\u0647 \u062a\u0631 \u06a9\u0646\u0646\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u062a\u062c\u0633\u0645 \u062f\u0627\u062f\u0647 \u0647\u0627:<\/strong> \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062e\u0644\u0627\u0635\u0647 \u0634\u062f\u0647 \u0631\u0627 \u062f\u0631 \u0642\u0627\u0644\u0628 \u0646\u0645\u0648\u062f\u0627\u0631\u0647\u0627 \u0648 \u0646\u0645\u0648\u062f\u0627\u0631\u0647\u0627 \u0627\u0631\u0627\u0626\u0647 \u062f\u0647\u0646\u062f \u0648 \u0628\u0647 \u062f\u0631\u06a9 \u0628\u0647\u062a\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627 \u06a9\u0645\u06a9 \u06a9\u0646\u0646\u062f.<\/p>\n<\/li>\n<\/ol>\n<h2>\u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0627\u062e\u0644\u06cc \u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc. \u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0686\u06af\u0648\u0646\u0647 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f.<\/h2>\n<p>\u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0627\u0632 \u0686\u0646\u062f\u06cc\u0646 \u062c\u0632\u0621 \u0627\u0635\u0644\u06cc \u062a\u0634\u06a9\u06cc\u0644 \u0634\u062f\u0647 \u0627\u0633\u062a:<\/p>\n<ol>\n<li>\n<p><strong>\u0628\u0631\u0686\u0633\u0628 \u0647\u0627\u06cc \u0631\u062f\u06cc\u0641:<\/strong> \u0641\u06cc\u0644\u062f(\u0647\u0627\u06cc) \u0645\u0648\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u062a\u0639\u0631\u06cc\u0641 \u0631\u062f\u06cc\u0641 \u0647\u0627 \u062f\u0631 \u062c\u062f\u0648\u0644 Pivot.<\/p>\n<\/li>\n<li>\n<p><strong>\u0628\u0631\u0686\u0633\u0628 \u0647\u0627\u06cc \u0633\u062a\u0648\u0646:<\/strong> \u0641\u06cc\u0644\u062f(\u0647\u0627\u06cc) \u0645\u0648\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u062a\u0639\u0631\u06cc\u0641 \u0633\u062a\u0648\u0646 \u0647\u0627 \u062f\u0631 \u062c\u062f\u0648\u0644 Pivot.<\/p>\n<\/li>\n<li>\n<p><strong>\u0645\u0642\u0627\u062f\u06cc\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627:<\/strong> \u0645\u0642\u0627\u062f\u06cc\u0631 \u0639\u062f\u062f\u06cc \u06a9\u0647 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0628\u0631\u0686\u0633\u0628 \u0633\u0637\u0631 \u0648 \u0633\u062a\u0648\u0646 \u062e\u0644\u0627\u0635\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u0641\u06cc\u0644\u062a\u0631 \u06af\u0632\u0627\u0631\u0634:<\/strong> \u06cc\u06a9 \u0641\u06cc\u0644\u062a\u0631 \u0627\u062e\u062a\u06cc\u0627\u0631\u06cc \u06a9\u0647 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u062f\u0631 \u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0631\u0627 \u0645\u062d\u062f\u0648\u062f \u06a9\u0646\u0646\u062f.<\/p>\n<\/li>\n<\/ol>\n<p>\u0647\u0646\u06af\u0627\u0645 \u0633\u0627\u062e\u062a \u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc\u060c \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0641\u06cc\u0644\u062f\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0646\u0648\u0627\u062d\u06cc \u0645\u0646\u0627\u0633\u0628 \u0628\u06a9\u0634\u0646\u062f \u0648 \u0631\u0647\u0627 \u06a9\u0646\u0646\u062f \u062a\u0627 \u062c\u062f\u0648\u0644 \u0631\u0627 \u0645\u0637\u0627\u0628\u0642 \u0628\u0627 \u0627\u0644\u0632\u0627\u0645\u0627\u062a \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062e\u0648\u062f \u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0647\u0646\u062f. \u0633\u067e\u0633 \u062c\u062f\u0648\u0644 Pivot \u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062e\u0644\u0627\u0635\u0647 \u0634\u062f\u0647 \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0631 \u0622\u0631\u0627\u06cc\u0634 \u0645\u062d\u0627\u0633\u0628\u0647 \u0648 \u0628\u0647 \u0631\u0648\u0632 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<h2>\u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u06a9\u0644\u06cc\u062f\u06cc \u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc.<\/h2>\n<p>\u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u06a9\u0644\u06cc\u062f\u06cc \u062c\u062f\u0627\u0648\u0644 Pivot \u0639\u0628\u0627\u0631\u062a\u0646\u062f \u0627\u0632:<\/p>\n<ol>\n<li>\n<p><strong>\u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631\u06cc:<\/strong> \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u062a\u0646\u0638\u06cc\u0645 \u0645\u062c\u062f\u062f\u060c \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u06cc\u0627 \u062d\u0630\u0641 \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u0641\u0648\u0631\u06cc \u0633\u0627\u062e\u062a\u0627\u0631 \u062c\u062f\u0648\u0644 \u0648 \u0645\u0634\u0627\u0647\u062f\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0632 \u062f\u06cc\u062f\u06af\u0627\u0647 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u0646\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u067e\u0648\u06cc\u0627:<\/strong> \u0628\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u0646\u0628\u0639\u060c \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0631\u0627\u06cc \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0646\u062a\u0627\u06cc\u062c \u0648 \u062d\u0641\u0638 \u062f\u0642\u062a \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0647 \u0631\u0648\u0632 \u06a9\u0631\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u0642\u0627\u0628\u0644\u06cc\u062a \u062d\u0641\u0627\u0631\u06cc:<\/strong> \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062e\u0644\u0627\u0635\u0647 \u0634\u062f\u0647 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0645\u0634\u0627\u0647\u062f\u0647 \u062c\u0632\u0626\u06cc\u0627\u062a \u0627\u0633\u0627\u0633\u06cc \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u0646\u062f \u0648 \u0628\u0647 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0639\u0645\u06cc\u0642 \u06a9\u0645\u06a9 \u06a9\u0646\u0646\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u0628\u0627\u0632\u062f\u0647 \u0632\u0645\u0627\u0646\u06cc:<\/strong> \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0628\u0647 \u0637\u0648\u0631 \u0642\u0627\u0628\u0644 \u062a\u0648\u062c\u0647\u06cc \u0632\u0645\u0627\u0646 \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648 \u06af\u0632\u0627\u0631\u0634 \u0631\u0627 \u06a9\u0627\u0647\u0634 \u0645\u06cc \u062f\u0647\u062f\u060c \u0632\u06cc\u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u067e\u06cc\u0686\u06cc\u062f\u0647 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0647\u0633\u062a\u0646\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u0627\u0631\u0627\u0626\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627:<\/strong> \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0642\u0627\u0644\u0628\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0645\u0627\u0646\u0646\u062f \u062c\u062f\u0627\u0648\u0644\u060c \u0646\u0645\u0648\u062f\u0627\u0631\u0647\u0627 \u06cc\u0627 \u0646\u0645\u0648\u062f\u0627\u0631\u0647\u0627 \u0627\u0631\u0627\u0626\u0647 \u06a9\u0646\u0646\u062f \u0648 \u062a\u062c\u0633\u0645 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0627\u0641\u0632\u0627\u06cc\u0634 \u062f\u0647\u0646\u062f.<\/p>\n<\/li>\n<\/ol>\n<h2>\u0627\u0646\u0648\u0627\u0639 \u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0631\u0627 \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f. \u0627\u0632 \u062c\u062f\u0627\u0648\u0644 \u0648 \u0644\u06cc\u0633\u062a \u0647\u0627 \u0628\u0631\u0627\u06cc \u0646\u0648\u0634\u062a\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/h2>\n<p>\u0627\u0646\u0648\u0627\u0639 \u0645\u062e\u062a\u0644\u0641\u06cc \u0627\u0632 \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0645\u0648\u062c\u0648\u062f \u0627\u0633\u062a \u06a9\u0647 \u0646\u06cc\u0627\u0632\u0647\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0631\u0627 \u0628\u0631\u0622\u0648\u0631\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f:<\/p>\n<ol>\n<li>\n<p><strong>\u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f:<\/strong> \u0631\u0627\u06cc\u062c \u062a\u0631\u06cc\u0646 \u0646\u0648\u0639 \u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u06a9\u0647 \u0642\u0627\u0628\u0644\u06cc\u062a \u0647\u0627\u06cc \u062e\u0644\u0627\u0635\u0647 \u0633\u0627\u0632\u06cc \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0627\u062f\u063a\u0627\u0645 \u0686\u0646\u062f\u06af\u0627\u0646\u0647:<\/strong> \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0632 \u0686\u0646\u062f\u06cc\u0646 \u0645\u0646\u0628\u0639 \u06cc\u0627 \u06a9\u0627\u0631\u0628\u0631\u06af \u062f\u0631 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0627\u062f\u063a\u0627\u0645 \u06a9\u0646\u0646\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0622\u0645\u0627\u0631\u06cc:<\/strong> \u062a\u0648\u0627\u0628\u0639 \u0622\u0645\u0627\u0631\u06cc \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0627\u06cc \u0645\u0627\u0646\u0646\u062f \u062a\u062d\u0644\u06cc\u0644 \u0631\u06af\u0631\u0633\u06cc\u0648\u0646\u060c \u0648\u0627\u0631\u06cc\u0627\u0646\u0633 \u0648 \u063a\u06cc\u0631\u0647 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0639\u0645\u06cc\u0642 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0645\u0648\u0631\u062f \u0645\u062d\u0627\u0633\u0628\u0647 \u0634\u062f\u0647:<\/strong> \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u062c\u062f\u0648\u0644 Pivot \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u0633\u0641\u0627\u0631\u0634\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u0646\u062f.<\/p>\n<\/li>\n<\/ol>\n<h2>\u0631\u0648\u0634 \u0647\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062c\u062f\u0648\u0644 Pivot\u060c \u0645\u0634\u06a9\u0644\u0627\u062a \u0648 \u0631\u0627\u0647 \u062d\u0644 \u0647\u0627\u06cc \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647.<\/h2>\n<p>\u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u062f\u0631 \u0632\u0645\u06cc\u0646\u0647 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u06a9\u0627\u0631\u0628\u0631\u062f \u067e\u06cc\u062f\u0627 \u0645\u06cc \u06a9\u0646\u0646\u062f\u060c \u0627\u0632 \u062c\u0645\u0644\u0647:<\/p>\n<ol>\n<li>\n<p><strong>\u062a\u062d\u0644\u06cc\u0644 \u06a9\u0633\u0628 \u0648 \u06a9\u0627\u0631:<\/strong> \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0641\u0631\u0648\u0634\u060c \u0628\u0627\u0632\u0627\u0631\u06cc\u0627\u0628\u06cc \u0648 \u0645\u0627\u0644\u06cc.<\/p>\n<\/li>\n<li>\n<p><strong>\u062f\u0627\u062f\u0647 \u06a9\u0627\u0648\u06cc:<\/strong> \u0628\u0631\u0627\u06cc \u06a9\u0634\u0641 \u0627\u0644\u06af\u0648\u0647\u0627 \u0648 \u0631\u0648\u0646\u062f\u0647\u0627 \u062f\u0631 \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0628\u0632\u0631\u06af.<\/p>\n<\/li>\n<li>\n<p><strong>\u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u0648\u062c\u0648\u062f\u06cc:<\/strong> \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0633\u0647\u0627\u0645 \u0648 \u0628\u0647\u06cc\u0646\u0647 \u0633\u0627\u0632\u06cc.<\/p>\n<\/li>\n<li>\n<p><strong>\u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0631\u0648\u0698\u0647:<\/strong> \u0628\u0631\u0627\u06cc \u067e\u06cc\u06af\u06cc\u0631\u06cc \u0648 \u0646\u0638\u0627\u0631\u062a \u0628\u0631 \u067e\u06cc\u0634\u0631\u0641\u062a \u067e\u0631\u0648\u0698\u0647.<\/p>\n<\/li>\n<\/ol>\n<p><strong>\u0645\u0634\u06a9\u0644\u0627\u062a \u0648 \u0631\u0627\u0647 \u062d\u0644 \u0647\u0627\u06cc \u0631\u0627\u06cc\u062c:<\/strong><\/p>\n<ol>\n<li>\n<p><strong>\u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0646\u0627\u062f\u0631\u0633\u062a:<\/strong> \u0642\u0628\u0644 \u0627\u0632 \u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc\u060c \u0645\u0646\u0628\u0639 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0631\u0627\u06cc \u062e\u0637\u0627 \u06cc\u0627 \u0646\u0627\u0633\u0627\u0632\u06af\u0627\u0631\u06cc \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0647 \u0631\u0648\u0632 \u0646\u0645\u06cc \u0634\u0648\u0646\u062f:<\/strong> \u0628\u0631\u0627\u06cc \u0645\u0646\u0639\u06a9\u0633 \u06a9\u0631\u062f\u0646 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u0646\u0628\u0639\u060c \u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0631\u0627 \u0628\u0627\u0632\u062e\u0648\u0627\u0646\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0627\u0632 \u062f\u0633\u062a \u0631\u0641\u062a\u0647:<\/strong> \u0627\u0632 \u06af\u0632\u06cc\u0646\u0647 Show Items With No Data \u0628\u0631\u0627\u06cc \u0646\u0645\u0627\u06cc\u0634 \u062a\u0645\u0627\u0645 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u0645\u06a9\u0646 \u062f\u0631 \u062c\u062f\u0648\u0644 Pivot \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627:<\/strong> \u0628\u0631\u0627\u06cc \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u0627\u0632 \u0627\u0631\u0627\u0626\u0647 \u062f\u0642\u06cc\u0642 \u062f\u0627\u062f\u0647 \u0647\u0627\u060c \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0645\u0646\u0627\u0633\u0628 \u0631\u0627 \u0627\u0639\u0645\u0627\u0644 \u06a9\u0646\u06cc\u062f.<\/p>\n<\/li>\n<\/ol>\n<h2>\u0645\u0634\u062e\u0635\u0627\u062a \u0627\u0635\u0644\u06cc \u0648 \u0633\u0627\u06cc\u0631 \u0645\u0642\u0627\u06cc\u0633\u0647 \u0647\u0627 \u0628\u0627 \u0627\u0635\u0637\u0644\u0627\u062d\u0627\u062a \u0645\u0634\u0627\u0628\u0647 \u062f\u0631 \u0642\u0627\u0644\u0628 \u062c\u062f\u0627\u0648\u0644 \u0648 \u0641\u0647\u0631\u0633\u062a.<\/h2>\n<p>\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0645\u0642\u0627\u06cc\u0633\u0647 \u0627\u06cc \u0628\u06cc\u0646 \u062c\u062f\u0627\u0648\u0644 Pivot \u0648 \u0627\u0635\u0637\u0644\u0627\u062d\u0627\u062a \u0645\u0634\u0627\u0628\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f:<\/p>\n<table>\n<thead>\n<tr>\n<th>\u0645\u0634\u062e\u0635\u0647<\/th>\n<th>\u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc<\/th>\n<th>\u062f\u0631\u062e\u0648\u0627\u0633\u062a Crosstab<\/th>\n<th>\u0646\u0645\u0648\u062f\u0627\u0631\u0647\u0627\u06cc \u0635\u0641\u062d\u0647 \u06af\u0633\u062a\u0631\u062f\u0647<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u0645\u0646\u0628\u0639 \u0627\u0637\u0644\u0627\u0639\u0627\u062a<\/td>\n<td>\u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647<\/td>\n<td>\u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647<\/td>\n<td>\u0635\u0641\u062d\u0627\u062a \u06af\u0633\u062a\u0631\u062f\u0647<\/td>\n<\/tr>\n<tr>\n<td>\u062a\u062c\u0645\u06cc\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627<\/td>\n<td>\u0622\u0631\u0647<\/td>\n<td>\u0622\u0631\u0647<\/td>\n<td>\u0645\u062d\u062f\u0648\u062f<\/td>\n<\/tr>\n<tr>\n<td>\u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0647\u0627\u06cc \u067e\u0648\u06cc\u0627<\/td>\n<td>\u0622\u0631\u0647<\/td>\n<td>\u062e\u06cc\u0631<\/td>\n<td>\u0622\u0631\u0647<\/td>\n<\/tr>\n<tr>\n<td>\u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0686\u0646\u062f \u0628\u0639\u062f\u06cc<\/td>\n<td>\u0622\u0631\u0647<\/td>\n<td>\u062e\u06cc\u0631<\/td>\n<td>\u062e\u06cc\u0631<\/td>\n<\/tr>\n<tr>\n<td>\u0645\u062d\u0627\u0633\u0628\u0627\u062a \u067e\u06cc\u0634\u0631\u0641\u062a\u0647<\/td>\n<td>\u0622\u0631\u0647<\/td>\n<td>\u0622\u0631\u0647<\/td>\n<td>\u0645\u062d\u062f\u0648\u062f<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\u0686\u0634\u0645 \u0627\u0646\u062f\u0627\u0632\u0647\u0627 \u0648 \u0641\u0646\u0627\u0648\u0631\u06cc \u0647\u0627\u06cc \u0622\u06cc\u0646\u062f\u0647 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc.<\/h2>\n<p>\u0622\u06cc\u0646\u062f\u0647 \u062c\u062f\u0627\u0648\u0644 Pivot \u0628\u0627 \u0627\u062f\u063a\u0627\u0645 \u0641\u0646\u0627\u0648\u0631\u06cc \u0647\u0627\u06cc \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0645\u06cc\u062f\u0648\u0627\u0631 \u06a9\u0646\u0646\u062f\u0647 \u0627\u0633\u062a. \u0628\u0631\u062e\u06cc \u0627\u0632 \u062a\u062d\u0648\u0644\u0627\u062a \u0628\u0627\u0644\u0642\u0648\u0647 \u0639\u0628\u0627\u0631\u062a\u0646\u062f \u0627\u0632:<\/p>\n<ol>\n<li>\n<p><strong>\u0647\u0648\u0634 \u0645\u0635\u0646\u0648\u0639\u06cc:<\/strong> \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0647\u0648\u0634 \u0645\u0635\u0646\u0648\u0639\u06cc \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062e\u0648\u062f\u06a9\u0627\u0631 \u06a9\u0631\u062f\u0647 \u0648 \u0628\u06cc\u0646\u0634\u200c\u0647\u0627\u06cc \u0645\u0631\u062a\u0628\u0637 \u0631\u0627 \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u06a9\u0646\u0646\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u067e\u0631\u062f\u0627\u0632\u0634 \u0632\u0628\u0627\u0646 \u0637\u0628\u06cc\u0639\u06cc:<\/strong> \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0627\u0632 \u067e\u0631\u0633\u200c\u0648\u200c\u062c\u0648\u0647\u0627 \u0628\u0647 \u0632\u0628\u0627\u0646 \u0637\u0628\u06cc\u0639\u06cc \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u06a9\u0646\u0646\u062f \u0648 \u0622\u0646\u0647\u0627 \u0631\u0627 \u06a9\u0627\u0631\u0628\u0631\u067e\u0633\u0646\u062f\u062a\u0631 \u06a9\u0646\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u06cc\u06a9\u067e\u0627\u0631\u0686\u0647 \u0633\u0627\u0632\u06cc \u0627\u0628\u0631\u06cc:<\/strong> \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0627\u0628\u0631 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0647\u0645\u06a9\u0627\u0631\u06cc \u0648 \u0627\u0634\u062a\u0631\u0627\u06a9 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0641\u0639\u0627\u0644 \u06a9\u0646\u0646\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u0644\u0627\u0646 \u062f\u0627\u062f\u0647:<\/strong> \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0628\u0632\u0631\u06af\u200c\u062a\u0631\u06cc \u0631\u0627 \u0645\u062f\u06cc\u0631\u06cc\u062a \u06a9\u0631\u062f\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644\u200c\u0647\u0627\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0631\u0627 \u06a9\u0627\u0631\u0622\u0645\u062f\u062a\u0631 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u0646\u062f.<\/p>\n<\/li>\n<\/ol>\n<h2>\u0686\u06af\u0648\u0646\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0627\u0632 \u0633\u0631\u0648\u0631\u0647\u0627\u06cc \u067e\u0631\u0648\u06a9\u0633\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f \u06cc\u0627 \u0628\u0627 \u062c\u062f\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u0645\u0631\u062a\u0628\u0637 \u0634\u062f.<\/h2>\n<p>\u0633\u0631\u0648\u0631\u0647\u0627\u06cc \u067e\u0631\u0648\u06a9\u0633\u06cc \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u062c\u062f\u0627\u0648\u0644 Pivot \u0631\u0627 \u0628\u0647 \u0631\u0648\u0634 \u0647\u0627\u06cc \u0632\u06cc\u0631 \u062a\u06a9\u0645\u06cc\u0644 \u06a9\u0646\u0646\u062f:<\/p>\n<ol>\n<li>\n<p><strong>\u062d\u0631\u06cc\u0645 \u062e\u0635\u0648\u0635\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627:<\/strong> \u0633\u0631\u0648\u0631\u0647\u0627\u06cc \u067e\u0631\u0648\u06a9\u0633\u06cc \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u0622\u062f\u0631\u0633 IP \u06a9\u0627\u0631\u0628\u0631 \u0631\u0627 \u0646\u0627\u0634\u0646\u0627\u0633 \u06a9\u0646\u0646\u062f \u0648 \u062f\u0631 \u062d\u06cc\u0646 \u06a9\u0627\u0631 \u0628\u0627 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062d\u0633\u0627\u0633 \u062f\u0631 \u062c\u062f\u0627\u0648\u0644 Pivot\u060c \u06cc\u06a9 \u0644\u0627\u06cc\u0647 \u0627\u0636\u0627\u0641\u06cc \u0627\u0632 \u062d\u0631\u06cc\u0645 \u062e\u0635\u0648\u0635\u06cc \u0627\u0631\u0627\u0626\u0647 \u062f\u0647\u0646\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u062e\u0631\u0627\u0634 \u062f\u0627\u062f\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627:<\/strong> \u0633\u0631\u0648\u0631\u0647\u0627\u06cc \u067e\u0631\u0648\u06a9\u0633\u06cc \u062e\u0631\u0627\u0634 \u062f\u0627\u062f\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0632 \u0686\u0646\u062f\u06cc\u0646 \u0645\u0646\u0628\u0639 \u0641\u0639\u0627\u0644 \u0645\u06cc \u06a9\u0646\u0646\u062f \u06a9\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062c\u062f\u0627\u0648\u0644 Pivot \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0634\u0648\u062f.<\/p>\n<\/li>\n<li>\n<p><strong>\u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0645\u0648\u0642\u0639\u06cc\u062a \u062c\u063a\u0631\u0627\u0641\u06cc\u0627\u06cc\u06cc:<\/strong> \u067e\u0631\u0627\u06a9\u0633\u06cc\u200c\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647 \u062c\u0645\u0639\u200c\u0622\u0648\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0632 \u0645\u06a9\u0627\u0646\u200c\u0647\u0627\u06cc \u062c\u063a\u0631\u0627\u0641\u06cc\u0627\u06cc\u06cc \u0645\u062e\u062a\u0644\u0641 \u06a9\u0645\u06a9 \u06a9\u0646\u0646\u062f \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0645\u0648\u0642\u0639\u06cc\u062a \u062c\u063a\u0631\u0627\u0641\u06cc\u0627\u06cc\u06cc \u0631\u0627 \u0628\u0627 \u062c\u062f\u0627\u0648\u0644 Pivot \u0628\u0647\u0628\u0648\u062f \u0628\u062e\u0634\u0646\u062f.<\/p>\n<\/li>\n<\/ol>\n<h2>\u0644\u06cc\u0646\u06a9 \u0647\u0627\u06cc \u0645\u0631\u0628\u0648\u0637\u0647<\/h2>\n<p>\u0628\u0631\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u06cc\u0634\u062a\u0631 \u062f\u0631 \u0645\u0648\u0631\u062f \u062c\u062f\u0627\u0648\u0644 Pivot \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0647 \u0645\u0646\u0627\u0628\u0639 \u0632\u06cc\u0631 \u0645\u0631\u0627\u062c\u0639\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<ol>\n<li>\n<p><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576\" target=\"_new\" rel=\"noopener nofollow\">\u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u0627\u06cc\u06a9\u0631\u0648\u0633\u0627\u0641\u062a: \u06cc\u06a9 PivotTable \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u06af \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<\/a><\/p>\n<\/li>\n<li>\n<p><a href=\"https:\/\/www.datacamp.com\/community\/tutorials\/pivot-tables-excel\" target=\"_new\" rel=\"noopener nofollow\">DataCamp: \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644<\/a><\/p>\n<\/li>\n<li>\n<p><a href=\"https:\/\/docs.oracle.com\/cd\/E28280_01\/bi.1111\/e10540\/pivot.htm\" target=\"_new\" rel=\"noopener nofollow\">\u0645\u0631\u06a9\u0632 \u0631\u0627\u0647\u0646\u0645\u0627\u06cc\u06cc \u0627\u0648\u0631\u0627\u06a9\u0644: \u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc<\/a><\/p>\n<\/li>\n<li>\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=3wfNl2L0Gf8\" target=\"_new\" rel=\"noopener nofollow\">\u06cc\u0648\u062a\u06cc\u0648\u0628: \u0645\u0642\u062f\u0645\u0647 \u0627\u06cc \u0628\u0631 \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc<\/a><\/p>\n<\/li>\n<\/ol>\n<p>\u0628\u0627 \u062a\u0633\u0644\u0637 \u0628\u0631 \u0647\u0646\u0631 \u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u06cc\u060c \u0627\u0641\u0631\u0627\u062f \u0648 \u06a9\u0633\u0628\u200c\u0648\u06a9\u0627\u0631\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u067e\u062a\u0627\u0646\u0633\u06cc\u0644 \u0648\u0627\u0642\u0639\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062e\u0648\u062f \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u0646\u062f\u060c \u062a\u0635\u0645\u06cc\u0645\u0627\u062a \u0622\u06af\u0627\u0647\u0627\u0646\u0647 \u0628\u06af\u06cc\u0631\u0646\u062f \u0648 \u0645\u0632\u06cc\u062a \u0631\u0642\u0627\u0628\u062a\u06cc \u062f\u0631 \u062f\u0646\u06cc\u0627\u06cc \u062f\u0627\u062f\u0647\u200c\u0645\u062d\u0648\u0631 \u0627\u0645\u0631\u0648\u0632\u06cc \u0628\u0647 \u062f\u0633\u062a \u0622\u0648\u0631\u0646\u062f.<\/p>","protected":false},"featured_media":469169,"menu_order":0,"template":"","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"class_list":["post-478446","wiki","type-wiki","status-publish","has-post-thumbnail","hentry"],"acf":{"faq_title":"Frequently Asked Questions about <mark>Pivot Table: A Comprehensive Guide<\/mark>","faq_items":[{"question":"What is a Pivot table?","answer":"<p>A Pivot table is a powerful data processing tool used in spreadsheet software and databases to summarize, analyze, and present complex data in a structured and user-friendly manner. It allows users to transform raw data into actionable insights by rearranging and summarizing information in a flexible and dynamic way.<\/p>"},{"question":"How did the concept of Pivot tables originate?","answer":"<p>The concept of Pivot tables originated in the field of Business Intelligence during the 1970s. The initial mention of Pivot tables can be traced back to a research paper titled \"On the Visualization of Multi-dimensional Data\" by J. Mecker and H. Landau in 1977. However, it wasn't until the 1990s that they gained widespread popularity with the advent of spreadsheet software like Microsoft Excel, which featured built-in Pivot table functionality.<\/p>"},{"question":"How does a Pivot table work?","answer":"<p>A Pivot table consists of several core components, including row labels, column labels, data values, and an optional report filter. Users can drag and drop fields into the appropriate areas to structure the table according to their analysis requirements. The Pivot table then automatically calculates and updates the summarized data as per the changes in the arrangement.<\/p>"},{"question":"What are the key features of Pivot tables?","answer":"<p>Pivot tables offer flexibility, dynamic updating, drill-down capability, time efficiency, and data presentation options. Users can quickly rearrange, add, or remove data fields to change the table's structure and view data from different perspectives. Pivot tables can also present data in various formats like tables, charts, or graphs, enhancing data visualization.<\/p>"},{"question":"What types of Pivot tables exist?","answer":"<p>There are different types of Pivot tables available, catering to diverse data analysis needs. Standard Pivot tables are the most common and provide basic summarization and analysis capabilities. Multiple Consolidation Pivot tables allow users to consolidate data from multiple sources or worksheets. Statistical Pivot tables offer advanced statistical functions, and Calculated Item Pivot tables enable custom calculations using existing data fields.<\/p>"},{"question":"How can Pivot tables be used, and what are common problems and solutions?","answer":"<p>Pivot tables find application in various fields such as business analysis, data mining, inventory management, and project management. Common problems include incorrect data, data not updating, missing data, and data formatting issues. Solutions involve verifying data sources, refreshing Pivot tables, using \"Show Items with No Data,\" and applying proper formatting.<\/p>"},{"question":"How do Pivot tables compare to similar terms?","answer":"<p>Here's a comparison between Pivot tables, Crosstab Query, and Spreadsheet Charts:<\/p><table><thead><tr><th>Characteristic<\/th><th>Pivot Table<\/th><th>Crosstab Query<\/th><th>Spreadsheet Charts<\/th><\/tr><\/thead><tbody><tr><td>Data Source<\/td><td>Databases<\/td><td>Databases<\/td><td>Spreadsheets<\/td><\/tr><tr><td>Data Aggregation<\/td><td>Yes<\/td><td>Yes<\/td><td>Limited<\/td><\/tr><tr><td>Dynamic Updates<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><\/tr><tr><td>Multidimensional Data<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><\/tr><tr><td>Advanced Calculations<\/td><td>Yes<\/td><td>Yes<\/td><td>Limited<\/td><\/tr><\/tbody><\/table>"},{"question":"What are the future perspectives and technologies related to Pivot tables?","answer":"<p>The future of Pivot tables is promising, with the integration of advanced technologies and data analytics. Potential developments include AI-driven Pivot tables, natural language processing support, cloud integration, and improved handling of big data analysis.<\/p>"},{"question":"How can proxy servers be associated with Pivot tables?","answer":"<p>Proxy servers can complement Pivot tables by providing an additional layer of data privacy and enabling data scraping from multiple sources, enhancing geolocation-based analysis.<\/p>"},{"question":"Where can I find more information about Pivot tables?","answer":"<p>For more information about Pivot tables, you can refer to the following resources:<\/p><ol><li><p><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576\" target=\"_new\">Microsoft Support: Create a PivotTable to analyze worksheet data<\/a><\/p><\/li><li><p><a href=\"https:\/\/www.datacamp.com\/community\/tutorials\/pivot-tables-excel\" target=\"_new\">DataCamp: Pivot Tables in Excel<\/a><\/p><\/li><li><p><a href=\"https:\/\/docs.oracle.com\/cd\/E28280_01\/bi.1111\/e10540\/pivot.htm\" target=\"_new\">Oracle Help Center: Creating Pivot Tables<\/a><\/p><\/li><li><p><a href=\"https:\/\/www.youtube.com\/watch?v=3wfNl2L0Gf8\" target=\"_new\">YouTube: Introduction to Pivot Tables<\/a><\/p><\/li><\/ol>"}]},"_links":{"self":[{"href":"https:\/\/oneproxy.pro\/ir\/wp-json\/wp\/v2\/wiki\/478446","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneproxy.pro\/ir\/wp-json\/wp\/v2\/wiki"}],"about":[{"href":"https:\/\/oneproxy.pro\/ir\/wp-json\/wp\/v2\/types\/wiki"}],"version-history":[{"count":0,"href":"https:\/\/oneproxy.pro\/ir\/wp-json\/wp\/v2\/wiki\/478446\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oneproxy.pro\/ir\/wp-json\/wp\/v2\/media\/469169"}],"wp:attachment":[{"href":"https:\/\/oneproxy.pro\/ir\/wp-json\/wp\/v2\/media?parent=478446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}