{ ] "actions" : [ "context" : "lia-deleted-state", Try this: [Prev Yr YTD Sales] =. "event" : "ProductMessageEdit", LITHIUM.MessageEditor.MessageQuote("#messageQuote", "#tinyMceEditor", "wrote:I have a pivot table that works for my team. In the Insert Calculated Filed dialog box: Give it a name by entering it in the Name field. "context" : "", "event" : "MessagesWidgetAnswerForm", return; { complete: function() { "action" : "rerender" LITHIUM.Auth.API_URL = '/t5/util/authcheckpage'; "context" : "envParam:messageUid,quiltName,product,contextId,contextUrl", { "actions" : [ "showCountOnly" : "false", 1. $( this ).toggleClass( 'menu-opened' ); ","ignoreOnChangeCssClasses":[],"disableFormOnSubmit":true,"buttonWrapperSelector":".lia-button-wrapper","showUnsavedDataWarningDataKey":"showUnsavedDataWarning","liaBodyTagId":"#lia-body"}); "event" : "RevokeSolutionAction", "initiatorDataMatcher" : "data-lia-kudos-id" "linkDisabled" : "false" "actions" : [ { "useCountToKudo" : "false", "action" : "rerender" I had to correct a few things.Even after my cube was fixed, the Quick Functions still weren't working.I found a solution that actually isn't documented anywhere on Sisense webpages or forums that I've come across so far, so I thought I'd share my custom function:=RPSUM([Total BUDGET],12)This formula takes the monthly budget for the year (as filtered by on my dashboard filter) and cumulatively adds it to the previous month's budget and cumulates from there. 8 Ways to Use Calculated Field in Pivot Table 1. "}); ] return; Create a Calendar Table* and build a relationship from the Date column of your Data Table to the Date column of the Calendar Table. I need to keep it split by Customer Type.How would I solve for this?\n\n","isUseLiaRichMedia":false,"autoTitleLink":"https://community.sisense.com/t5/forums/v5/forumtopicpage.threadeddetaildisplay.inlinemessagereplyeditor_0.form.messageeditor.tinymceeditor:getautotitle?t:ac=board-id/build_analytics/message-id/851/thread-id/851","isGteEditorV2":true,"linkTooltipTexts":{"bareURL":"Bare URL","unlink":"Unlink","openLink":"Open link","autoTitle":"Auto-title"},"elementSelector":"#tinyMceEditor","preLoadedAddOnAssetUrls":["/html/js/lib/tinymce/4.7.13/themes/modern/theme.js","/html/js/lib/tinymce/4.7.13/plugins/lists/plugin.js","/html/js/lib/tinymce/4.7.13/plugins/compat3x/plugin.js","/html/js/lib/tinymce/4.7.13/plugins/image/plugin.js","/html/js/lib/tinymce/4.7.13/plugins/link/plugin.js","/html/js/lib/tinymce/4.7.13/plugins/textcolor/plugin.js","/html/js/lib/tinymce/4.7.13/plugins/table/plugin.js","/html/js/lib/tinymce/4.7.13/plugins/tabfocus/plugin.js","/html/js/lib/tinymce/4.7.13/plugins/paste/plugin.js","/plugin/editors/tinymce/plugins/spoiler/plugin.js","/plugin/editors/tinymce/plugins/spoiler/langs/en.js","/plugin/editors/tinymce/plugins/insertcode/plugin.js","/plugin/editors/tinymce/plugins/insertcode/langs/en.js","/plugin/editors/tinymce/plugins/liarichmedia/plugin.js","/plugin/editors/tinymce/plugins/liarichmedia/langs/en.js","/plugin/editors/tinymce/plugins/liaexpandtoolbar/plugin.js","/plugin/editors/tinymce/plugins/liaexpandtoolbar/langs/en.js","/plugin/editors/tinymce/plugins/liaquote/plugin.js","/plugin/editors/tinymce/plugins/liaquote/langs/en.js","/plugin/editors/tinymce/plugins/liamacros/plugin.js","/plugin/editors/tinymce/plugins/liamacros/langs/en.js","/plugin/editors/tinymce/plugins/liafullscreendone/plugin.js","/plugin/editors/tinymce/plugins/liafullscreendone/langs/en.js","/html/js/lib/tinymce/4.7.13/plugins/code/plugin.js","/plugin/editors/tinymce/plugins/toc/plugin.js","/plugin/editors/tinymce/plugins/toc/langs/en.js","/plugin/editors/tinymce/plugins/mentions/plugin.js","/plugin/editors/tinymce/plugins/mentions/langs/en.js","/html/js/lib/tinymce/4.7.13/plugins/noneditable/plugin.js","/plugin/editors/tinymce/plugins/emoticons/plugin.js","/plugin/editors/tinymce/plugins/emoticons/langs/en.js","/plugin/editors/tinymce/plugins/extcodesample/plugin.js"],"isOoyalaVideoEnabled":false,"isInlineLinkEditingEnabled":false,"optionsParam":{"messageMentionTemplate":"#{title}","spellcheckerUrl":"/spellchecker/lucene","useUserMentions":true,"toolbarSelector":".mce-toolbar-grp","useProductMentions":false,"mediaUploadOptions":{"attachmentOverlayText":"Drop your files here","createVideoLink":"https://community.sisense.com/t5/forums/v5/forumtopicpage.threadeddetaildisplay.inlinemessagereplyeditor_0.form.messageeditor.tinymceeditor:createvideo?t:ac=board-id/build_analytics/message-id/851/thread-id/851","imageUploadSettings":{"validImageExts":"*.jpg;*.JPG;*.jpeg;*.JPEG;*.gif;*.GIF;*.png;*.PNG, *webm","maxFileBytes":3145728,"maxImagesPerUpload":100},"editorOverlayText":"Drop your media files here","copyPasteSettings":{"copyPasteEvent":"LITHIUM:liaCopyPasteImages","copyPasteBatchSize":3,"copyPasteCss":"lia-copypaste-placeholder","username":"Anonymous"},"videoImageTooltip":"\"Please wait while we upload and process your video. "action" : "rerender" } "context" : "", }, LITHIUM.InformationBox({"updateFeedbackEvent":"LITHIUM:updateAjaxFeedback","componentSelector":"#informationbox_12","feedbackSelector":".InfoMessage"}); So, for example, I'm trying to build 3 new columns in the pivot table:March Budget YTD = January Budget + February Budget + March BudgetMarch Revenue YTD =January Revenue + February Revenue + March RevenueMarch Variance YTD = March Revenue YTD - March Budget YTD\n, I need these additional columns for each month, either added to this existing pivot table, or in a new one with a filter for the month the team wants to look at.\n, Is this possible in a pivot table? evt.preventDefault(); "eventActions" : [ } "actions" : [ This may take a few minutes, so please check back later.\"","enableFormActionButtonsEvent":"LITHIUM:enableFormActionButtons","videoUploadingUrlsLink":"https://community.sisense.com/t5/forums/v5/forumtopicpage.threadeddetaildisplay.inlinemessagereplyeditor_0.form.messageeditor.tinymceeditor:videouploadingurls?t:ac=board-id/build_analytics/message-id/851/thread-id/851","isOverlayVisible":true,"videoEmbedThumbnail":"/i/skins/default/video-loading-new.gif","videoStatusUpdateLink":"https://community.sisense.com/t5/forums/v5/forumtopicpage.threadeddetaildisplay.inlinemessagereplyeditor_0.form.messageeditor.tinymceeditor:videostatusupdate?t:ac=board-id/build_analytics/message-id/851/thread-id/851","token":"DZHbiOEqTrUvLQPLch0RMkPFweqYRTCOYRV29cqbleE. Right click inside any date and choose Group option. ] To show both the Fiscal YTD and MTD amounts in the pivot table, you can add two more columns to the source data. "eventActions" : [ } "action" : "rerender" } } It looks like this:\n\nThe variance column is a simple formula showing the difference between Budget and Revenue (Revenue - Budget).\nI have received a request to expand this pivot (or create a new one based off of the data in this current one) that calculates the YTD for each of these fields. LITHIUM.AjaxSupport({"ajaxOptionsParam":{"event":"LITHIUM:getAutoTitle","parameters":{"javascript.ignore_combine_and_minify":"true"}},"tokenId":"ajax","elementSelector":document,"action":"getAutoTitle","feedbackSelector":false,"url":"https://community.sisense.com/t5/forums/v5/forumtopicpage.threadeddetaildisplay.inlinemessagereplyeditor_0.form.messageeditor.tinymceeditor:getautotitle?t:ac=board-id/build_analytics/message-id/851/thread-id/851","ajaxErrorEventName":"LITHIUM:ajaxError","token":"bRmJnSdLk4-FF8rJ9x7bOeQ8OmIKtjz10VRuOGlN9Lw. "actions" : [ LITHIUM.InlineMessageReplyEditor({"openEditsSelector":".lia-inline-message-edit","ajaxFeebackSelector":"#inlinemessagereplyeditor_0 .lia-inline-ajax-feedback","collapseEvent":"LITHIUM:collapseInlineMessageEditor","confimationText":"You have other message editors open and your data inside of them might be lost. "action" : "rerender" LITHIUM.InformationBox({"updateFeedbackEvent":"LITHIUM:updateAjaxFeedback","componentSelector":"#informationbox_3","feedbackSelector":".InfoMessage"}); { "actions" : [ $(divContainer).fadeIn(); ] Modify an Existing Calculated Field 5. } LITHIUM.InformationBox({"updateFeedbackEvent":"LITHIUM:updateAjaxFeedback","componentSelector":"#informationbox_0","feedbackSelector":".InfoMessage"}); "event" : "removeMessageUserEmailSubscription", "actions" : [ Figure 4. "entity" : "3430", "initiatorBinding" : true, One that's end in December (Default) and other that ends in June. "actions" : [ }, LITHIUM.TokenInputAutoComplete({"multiUserSelectEvent":"LITHIUM:multiUserSelectEvent","emailValidationAndTileCreation":false,"tokenInputAddItemEvent":"LITHIUM:tokenInputAddItem","deleteSelector":".lia-token-input-delete-token","tokenSelector":".lia-token-input-token","resolveCsvRecipientUsers":"LITHIUM:resolveCsvRecipientUsers","url":"https://community.sisense.com/t5/forums/v5/forumtopicpage.productsfield.productsfield:tokeninputautocomplete?t:ac=board-id/build_analytics/message-id/851/thread-id/851&t:cp=products/block/producteditblocks","renderImagesEvent":"LITHIUM:renderImages","tokenInputValueChangeEvent":"LITHIUM:tokenInputValueChange","invalidCsvUsersErrorTimeout":10000,"disabled":false,"config":{"searchDelay":300,"method":"GET","allowTabOut":false,"pseudoParentSelector":".lia-panel-dialog","noResultsText":"No matches","classes":{"highlightedToken":"lia-token-input-highlighted-token","inputCsvError":".lia-invalid-csv-recipients-error-msg","selectedDropdownItem":"lia-token-input-selected-dropdown-item","dropdownItem2":"lia-token-input-dropdown-item2","inputToken":"lia-token-input-input-token","tokenDelete":"lia-token-input-delete-token","selectedToken":"lia-token-input-selected-token","dropdownItem":"lia-token-input-dropdown-item","deleteHighlight":"lia-token-input-delete-highlight","dropdown":"lia-content lia-token-input-dropdown lia-products-items-list","token":"lia-token-input-token","inputFormFieldError":"lia-form-field-error","tokenList":"lia-token-input-list lia-products-field-token-list","inputValidationError":"lia-token-input-validation-error"},"autoSelectFirstResult":true,"animateDropdown":false,"allowFreeTagging":false,"minChars":1,"searchingText":"Searching","resultsFormatter":LITHIUM.ProductsFieldFormatter.resultsFormatter,"hintText":"Type a product name","preventDuplicates":true,"tokenFormatter":LITHIUM.ProductsFieldFormatter.tokenFormatter,"deleteText":"","tokenLimit":100,"crossDomain":false,"queryParam":"q"},"inputSelector":"#lia-products","invalidEmailErrorMessage":"is an invalid format and is removed from the list. It looks like this:\n\nThe variance column is a simple formula showing the difference between Budget and Revenue (Revenue - Budget).\nI have received a request to expand this pivot (or create a new one based off of the data in this current one) that calculates the YTD for each of these fields. "event" : "ProductAnswer", $(document).ready(function () { Drag and drop the same field 2 times. "actions" : [ "useCountToKudo" : "false", "event" : "expandMessage", "action" : "pulsate" } ] "event" : "AcceptSolutionAction", Month (number 1 to 12) & Amount, Add two more columns, with formulae: CurMth =IF (D4=CURMTH,E4,0) YTD =IF (D4<=CURMTH,E4,0) Copy these down all the data rows. }, }, In the PivotTable fields panel that appears, we'll drag Team to the rows box and Games to the Values box: The following pivot table will appear: STEP 5: You can manually change the name of the Sum of SALES2 Field by clicking in the cell's title within the Pivot Table: STEP 6: We can insert a Pivot Chart by . }, } This will help you understand how the calculation works. "action" : "rerender" "actions" : [ . } ","loaderSelector":"#threadeddetaildisplaymessageviewwrapper_0 .lia-message-body-loader .lia-loader","expandedRepliesSelector":".lia-inline-message-reply-form-expanded"}); { } "actions" : [ ', 'ajax');","content":"Turn off suggestions"}],"prefixTriggerTextLength":0},"inputSelector":"#noteSearchField_0","redirectToItemLink":false,"url":"https://community.sisense.com/t5/forums/v5/forumtopicpage.searchformv32.notesearchfield.notesearchfield:autocomplete?t:ac=board-id/build_analytics/message-id/851/thread-id/851&t:cp=search/contributions/page","resizeImageEvent":"LITHIUM:renderImages"}); ', 'ajax');","content":", Turn off suggestions"}],"prefixTriggerTextLength":3},"inputSelector":"#messageSearchField_1","redirectToItemLink":false,"url":"https://community.sisense.com/t5/forums/v5/forumtopicpage.searchformv32.tkbmessagesearchfield.messagesearchfield:autocomplete?t:ac=board-id/build_analytics/message-id/851/thread-id/851&t:cp=search/contributions/page","resizeImageEvent":"LITHIUM:renderImages"}); "actions" : [ LITHIUM.AutoComplete({"options":{"autosuggestionAvailableInstructionText":"Auto-suggestions available. LITHIUM.InformationBox({"updateFeedbackEvent":"LITHIUM:updateAjaxFeedback","componentSelector":"#informationbox_10","feedbackSelector":".InfoMessage"}); LITHIUM.AjaxSupport({"ajaxOptionsParam":{"event":"LITHIUM:removeNewAttachment","parameters":{"clientId":"inlinemessagereplyeditor_0","attachmentKey":"b294d8bd-748f-49dd-95b1-45f92e4bd6eb"}},"tokenId":"ajax","elementSelector":"#inlinemessagereplyeditor_0 .lia-file-upload","action":"removeNewAttachment","feedbackSelector":"#attachmentsComponent","url":"https://community.sisense.com/t5/forums/v5/forumtopicpage.threadeddetaildisplay.inlinemessagereplyeditor_0.form.attachmentscomponent:removenewattachment?t:ac=board-id/build_analytics/message-id/851/thread-id/851","ajaxErrorEventName":"LITHIUM:ajaxError","token":"x1yKWnrbArJUAVjyBldPph4bmni8ckgLTQHHAFreLMk. The Excel function YEARFRAC() calculates the percentage of the year that has passed since a starting date. { ] Then divide that value by the YTD volume.. "}); LITHIUM.Cache.CustomEvent.set([{"elementId":"link_9","stopTriggerEvent":false,"fireEvent":"LITHIUM:labelSelected","triggerEvent":"click","eventContext":{"uid":10,"selectedLabel":"dashboards & reporting","title":"Dashboards & Reporting"}},{"elementId":"link_10","stopTriggerEvent":false,"fireEvent":"LITHIUM:labelSelected","triggerEvent":"click","eventContext":{"uid":45,"selectedLabel":"finance analytics","title":"Finance Analytics"}}]); "displayStyle" : "horizontal", Please help me in resolving this issue. "event" : "expandMessage", data: {"userId": userId}, "componentId" : "forums.widget.message-view", "event" : "QuickReply", You name this measure [Total Sales]. One approach is to add a formula based column to your table for the "month", then place this in the Report Filter in your pivot table and select only the months you wish. LITHIUM.DropDownMenuVisibilityHandler({"selectors":{"menuSelector":"#actionMenuDropDown_3","menuItemsSelector":".lia-menu-dropdown-items"}}); "messageViewOptions" : "1101110111111111111110111110100101111101", LITHIUM.AjaxSupport({"ajaxOptionsParam":{"event":"LITHIUM:removeExistingAttachment","parameters":{"clientId":"inlinemessagereplyeditor_0","attachmentKey":"b294d8bd-748f-49dd-95b1-45f92e4bd6eb"}},"tokenId":"ajax","elementSelector":"#inlinemessagereplyeditor_0 .lia-file-upload","action":"removeExistingAttachment","feedbackSelector":"#attachmentsComponent","url":"https://community.sisense.com/t5/forums/v5/forumtopicpage.threadeddetaildisplay.inlinemessagereplyeditor_0.form.attachmentscomponent:removeexistingattachment?t:ac=board-id/build_analytics/message-id/851/thread-id/851","ajaxErrorEventName":"LITHIUM:ajaxError","token":"x_O-SXK3JpLQPZ6iTM5M-BwdpgV1ZAQLuYaRJ3r-Mmg. By adding the 12 it knows to repeat after 12 periods, so it takes care of the entire year for me.I was able to apply the RPSUM with 12 periods to my Budget, Revenue, and Variance (Revenue - Budget) columns.It was a long walk but I got there! ] "actions" : [ Press ALT-F10 for toolbar and Escape to return to the editor. }, { How to calculate YTD, QTD, MTD and WTD? In this case, select cells B2:E22 Step 2. }); I was aware of the RSUM quick functions, but they weren't working on the data cube my dashboard was connected to. "actions" : [ "context" : "", } LITHIUM.Auth.KEEP_ALIVE_URL = '/t5/status/blankpage?keepalive'; ] "parameters" : { "action" : "rerender" LITHIUM.AutoComplete({"options":{"autosuggestionAvailableInstructionText":"Auto-suggestions available. Excel automatically selects the data for you. window.localStorage.setItem('cmp-profile-completion-meter-collapsed', 1); "event" : "MessagesWidgetCommentForm", } LITHIUM.AjaxSupport({"ajaxOptionsParam":{"event":"LITHIUM:refreshAttachments","parameters":{"clientId":"inlinemessagereplyeditor_0","attachmentKey":"b294d8bd-748f-49dd-95b1-45f92e4bd6eb"}},"tokenId":"ajax","elementSelector":"#inlinemessagereplyeditor_0","action":"refreshAttachments","feedbackSelector":"#attachmentsComponent","url":"https://community.sisense.com/t5/forums/v5/forumtopicpage.threadeddetaildisplay.inlinemessagereplyeditor_0.form.attachmentscomponent:refreshattachments?t:ac=board-id/build_analytics/message-id/851/thread-id/851","ajaxErrorEventName":"LITHIUM:ajaxError","token":"zxDqbWwWWVBJXetMVYmPWvgpgXbh7NGqxcsVFMBibAs. $('.user-profile-card').hide(); "context" : "", "context" : "envParam:quiltName,expandedQuiltName", Click OK. { LITHIUM.Tooltip({"bodySelector":"body#lia-body","delay":30,"enableOnClickForTrigger":false,"predelay":10,"triggerSelector":"#lia-productsField .lia-token-input-readonly-token","tooltipContentSelector":"#lia-productsField_0-tooltip-element .content","position":["bottom","left"],"tooltipElementSelector":"#lia-productsField_0-tooltip-element","events":{"def":"focus mouseover,blur mouseout"},"hideOnLeave":true}); "initiatorDataMatcher" : "data-lia-message-uid" { '; { { The maximum file size is 5 MB. First, we need to subtract the base sales from the sum of sales to determine the commissionable net sales amount. { $.ajax({ } LITHIUM.FileDragDrop({"urls":{"uploadUrl":"https://community.sisense.com/t5/forums/v5/forumtopicpage.threadeddetaildisplay.inlinemessagereplyeditor_0.form.attachmentscomponent:uploadfileaction/attachments-key/b294d8bd-748f-49dd-95b1-45f92e4bd6eb?t:ac=board-id/build_analytics/message-id/851/thread-id/851"},"selectors":{"container":"#filedragdrop","feedbackElement":"#dragDropFeedback .AjaxFeedback","cancelUploadProgress":"lia-remove-attachment-inprogress","fileUpload":"#filedragdrop .lia-file-upload"},"events":{"uploadDoneEvent":"LITHIUM:uploadDone","refreshAttachmentsEvent":"LITHIUM:refreshAttachments","formHasErrorsEvent":"LITHIUM:formHasErrors"},"misc":{"actionTokenId":"uploadFile","fileDataParam":"Filedata","isEditorGteV2":true,"actionToken":"hrtIKMXCAIlHrKT6vvW19DDpvYQPrqzATYhRBYPDyKU. data: {"userId": userId}, 25,000 / 80,000 / 3,000 (=March '06 - March '05) I can calculate with multiple pivot tables, but would like to just create one and put in proper fields and funtions. { dataType: 'html', { We'll use it to help calculate the year fraction. "context" : "envParam:messageUid,quiltName,product,contextId,contextUrl", "}); "useSimpleView" : "false", 2,277. var left = $(this).offset().left; Register To Reply 02-18-2011, 08:42 AM #3 tania_del "actions" : [ Click Okay. This may, or may not, be the same sheet where your pivot table is located. { You can group the dates by days or months. ] "kudosable" : "true", LITHIUM.SearchAutoCompleteToggle({"containerSelector":"#searchautocompletetoggle","enableAutoCompleteSelector":".search-autocomplete-toggle-link","enableAutocompleteSuccessEvent":"LITHIUM:ajaxSuccess:enableAutoComplete","disableAutoCompleteSelector":".lia-autocomplete-toggle-off","disableAutocompleteSuccessEvent":"LITHIUM:ajaxSuccess:disableAutoComplete","autoCompleteSelector":".lia-autocomplete-input"}); { LITHIUM.AjaxSupport({"ajaxOptionsParam":{"event":"LITHIUM:removeInProgressNewAttachment","parameters":{"clientId":"inlinemessagereplyeditor_0","attachmentKey":"b294d8bd-748f-49dd-95b1-45f92e4bd6eb"}},"tokenId":"ajax","elementSelector":"#inlinemessagereplyeditor_0 .lia-file-upload","action":"removeInProgressNewAttachment","feedbackSelector":"#attachmentsComponent","url":"https://community.sisense.com/t5/forums/v5/forumtopicpage.threadeddetaildisplay.inlinemessagereplyeditor_0.form.attachmentscomponent:removeinprogressnewattachment?t:ac=board-id/build_analytics/message-id/851/thread-id/851","ajaxErrorEventName":"LITHIUM:ajaxError","token":"29LG7cwwF44lA28G7H3KnSeNkiv0Mqk5TGwWdUY8J4w. I need these additional columns for each month, either added to this existing pivot table, or in a new one with a filter for the month the team wants to look at. var left = $(this).offset().left; LITHIUM.AjaxSupport({"ajaxOptionsParam":{"event":"LITHIUM:lazyLoadComponent","parameters":{"componentId":"messages.widget.emoticons-lazy-load-runner"}},"tokenId":"ajax","elementSelector":"#inlinemessagereplyeditor_0","action":"lazyLoadComponent","feedbackSelector":false,"url":"https://community.sisense.com/t5/forums/v5/forumtopicpage.threadeddetaildisplay.inlinemessagereplyeditor_0:lazyloadcomponent?t:ac=board-id/build_analytics/message-id/851/thread-id/851","ajaxErrorEventName":"LITHIUM:ajaxError","token":"iizwXy5TziBpWblYEVY1EwBODkibGUslSxkVYxg_8KM. "disableLabelLinks" : "false", LITHIUM.AjaxSupport({"ajaxOptionsParam":{"event":"LITHIUM:autosaveInline","parameters":{"clientId":"inlinemessagereplyeditor_0"}},"tokenId":"ajax","elementSelector":"#form_0","action":"autosaveInline","feedbackSelector":"#form_0","url":"https://community.sisense.com/t5/forums/v5/forumtopicpage.threadeddetaildisplay.inlinemessagereplyeditor_0.form:autosaveinline?t:ac=board-id/build_analytics/message-id/851/thread-id/851","ajaxErrorEventName":"LITHIUM:ajaxError","token":"umUk0iniARti0qpM9WVgn-tFJ4xKjZJ8fCN6-pVKVyc. }, } ] "context" : "envParam:quiltName", evt.stopPropagation(); LITHIUM.Form.focusFieldByRules([{"id":"tinyMceEditor","priority":"optional"},{"id":"lia-parentMessageRef","priority":"optional"},{"id":"lia-containerId","priority":"optional"},{"id":"lia-mediaSnippetUrl","priority":"optional"},{"id":"lia-products","priority":"optional"}]); To create the pivot table, we'll highlight the cells in the range A1:E9, then click the PivotTable icon within the Insert tab along the top ribbon. "disallowZeroCount" : "false", LITHIUM.InformationBox({"updateFeedbackEvent":"LITHIUM:updateAjaxFeedback","componentSelector":"#informationbox_14","feedbackSelector":".InfoMessage"}); Want to obtain tallies for each month of the count or amount values, based on the start and end date of a product subscription. ","uploadDoneEvent":"LITHIUM:uploadDone","disableFormActionButtonsEvent":"LITHIUM:disableFormActionButtons","inProgressAttachmentSelector":".lia-in-progress-attachment","removePreviewAttachmentEvent":"LITHIUM:removePreviewAttachment","removeNewAttachmentEvent":"LITHIUM:removeNewAttachment","passToAttachmentEvent":"LITHIUM:passToAttachment"}); "action" : "rerender" LITHIUM.InformationBox({"updateFeedbackEvent":"LITHIUM:updateAjaxFeedback","componentSelector":"#informationbox_23","feedbackSelector":".InfoMessage"}); }, JavaScript is disabled. $('.user-profile-card', this).show(); "parameters" : { Looking to learn how to create a pivot table to show tallies per month from a data set that includes. "action" : "rerender" $('.lia-panel-heading-bar-toggle').addClass('collapsed'); "action" : "rerender" Maximum number of attachments allowed is: 5","attachmentErrorSelector":"#inlinemessagereplyeditor_0 .lia-file-error-msg","cancelAttachmentProgressCss":"lia-remove-attachment-inprogress","fileUploadSelector":"#inlinemessagereplyeditor_0 .lia-file-upload","newAttachmentSelector":"#inlinemessagereplyeditor_0 .lia-new-attachment","attachmentsTooManyErrorSelector":"#inlinemessagereplyeditor_0 .lia-attachment-upload-error-many","fileTypeErrorText":"The file type () is not supported. ] "actions" : [ LITHIUM.AjaxSupport.fromLink('#enableAutoComplete', 'enableAutoComplete', '#ajaxfeedback_0', 'LITHIUM:ajaxError', {}, 'TAtVs-m5-LWDtCJHt6WeufZcmP3YCZYyd_i_Vv560dk. STEP 1: Insert a Pivot Table by clicking on your data and going to Insert > Pivot Table STEP 2: In the Create PivotTable dialog box, Select Table range and then click on New Worksheet. In Excel 2007, this will be Pivot Table Tools > Options > Formulas > Solve Order. { Create a running total with YearMonth as the base field. } Press ALT-F10 for toolbar and Escape to return to the editor. }, "truncateBodyRetainsHtml" : "false", } { "event" : "addMessageUserEmailSubscription", LITHIUM.AjaxSupport.useTickets = false; { So, for example, I'm trying to build 3 new columns in the pivot table:March Budget YTD = January Budget + February Budget + March BudgetMarch Revenue YTD =January Revenue + February Revenue + March RevenueMarch Variance YTD = March Revenue YTD - March Budget YTD\nI need these additional columns for each month, either added to this existing pivot table, or in a new one with a filter for the month the team wants to look at.\nIs this possible in a pivot table? "context" : "", }, } } } ] "action" : "rerender" ] } LITHIUM.AjaxSupport({"ajaxOptionsParam":{"useLoader":true,"blockUI":"","event":"LITHIUM:reRenderInlineEditor","parameters":{"clientId":"inlinemessagereplyeditor_0"}},"tokenId":"ajax","elementSelector":"#inlinemessagereplyeditor_0","action":"reRenderInlineEditor","feedbackSelector":"#inlinemessagereplyeditor_0","url":"https://community.sisense.com/t5/forums/v5/forumtopicpage.threadeddetaildisplay.inlinemessagereplyeditor_0:rerenderinlineeditor?t:ac=board-id/build_analytics/message-id/851/thread-id/851","ajaxErrorEventName":"LITHIUM:ajaxError","token":"slTxOTwlbjjdh8HmrNXe2TQIDVQ-J6DDiERj27OLxvQ. If you want to show this next to the monthly amount, just bring in that same value again. }); "actions" : [ This forum has migrated to Microsoft Q&A. LITHIUM.FileDragDrop({"urls":{"uploadUrl":"https://community.sisense.com/t5/forums/v5/forumtopicpage.threadeddetaildisplay.inlinemessagereplyeditor_0.form.attachmentscomponent:uploadfileaction/attachments-key/b294d8bd-748f-49dd-95b1-45f92e4bd6eb?t:ac=board-id/build_analytics/message-id/851/thread-id/851"},"selectors":{"container":"#filedragdrop","feedbackElement":"#dragDropFeedback .AjaxFeedback","cancelUploadProgress":"lia-remove-attachment-inprogress","fileUpload":"#filedragdrop .lia-file-upload"},"events":{"uploadDoneEvent":"LITHIUM:uploadDone","refreshAttachmentsEvent":"LITHIUM:refreshAttachments","formHasErrorsEvent":"LITHIUM:formHasErrors"},"misc":{"actionTokenId":"uploadFile","fileDataParam":"Filedata","isEditorGteV2":true,"actionToken":"hrtIKMXCAIlHrKT6vvW19DDpvYQPrqzATYhRBYPDyKU.