FAQ - Analytics

Quanto FAQ - Analytics

Stock Analyiser

GO TO ANALYTICAL->SELECT STOCK ANALYISER->SELECT TO WEREHOUSE/ALL/RETAIL AS REQUIRED(IF YOU SELECT ALL DATA OF ALL PURCHASE,SALES & STOCK WILL COME)-> SELECT THE LOCATION->CHOOSE ANY FILTER AS REQUIRED (MIN OF ONE FILTER MUST BE SELECTED TO RUN THE REPORT)-> SELECT THE DATA ON THE RIGHT SIDE & CHOOSE THE NEXT FILTER AS REQUIRED->LIKEWISE EACH FILTER CAN BE SELECTED AND DRILLED DOWN AS REQUIRED-> ALL THE SELECTIONS MADE CAN BE CONVERTED INTO REPORT BY CLICKING ON THE REPORT OPTION IN THE TOP-> BOX WILL APPEAR-> NOW CLICK ON THE COLUMN GROUP DROPDOWN & SELECT THE FIELD WHICH YOU REQUIRE TO BE PLACED IN THE COLUMN SIDE OF THE REPORT-> SELECT THE ATTRIBUTES BELOW LIKE THE PRODUCT , BRAND ETC AS REQUIRED-> CLICK VIEW TO VIEW THE REPORT->YOU CAN ALSO SAVE THE REPORT BU GIVING A TITLE TO IT IN THE TITLE COLUMN & CLICK THE SAVE BUTTON BELOW->CLICK EXCEL TO DOWNLOAD THE REPORT IN EXCEL

Purchase Analyiser

GO TO ANALYTICAL->SELECT PURCHASE ANALYISER->SELECT THE DATE RANGE AS REQUIRED->CHOOSE ANY FILTER AS REQUIRED (MIN OF ONE FILTER MUST BE SELECTED TO RUN THE REPORT)-> SELECT THE DATA ON THE RIGHT SIDE & CHOOSE THE NEXT FILTER AS REQUIRED->LIKEWISE EACH FILTER CAN BE SELECTED AND DRILLED DOWN AS REQUIRED-> ALL THE SELECTIONS MADE CAN BE CONVERTED INTO REPORT BY CLICKING ON THE REPORT OPTION IN THE TOP-> BOX WILL APPEAR-> NOW CLICK ON THE COLUMN GROUP DROPDOWN & SELECT THE FIELD WHICH YOU REQUIRE TO BE PLACED IN THE COLUMN SIDE OF THE REPORT-> SELECT THE ATTRIBUTES BELOW LIKE THE PRODUCT , BRAND ETC AS REQUIRED-> CLICK VIEW TO VIEW THE REPORT->YOU CAN ALSO SAVE THE REPORT BU GIVING A TITLE TO IT IN THE TITLE COLUMN & CLICK THE SAVE BUTTON BELOW->CLICK EXCEL TO DOWNLOAD THE REPORT IN EXCEL

Sales Analyiser

GO TO ANALYTICAL->SELECT SALES ANALYISER->SELECT THE DATE RANGE AS REQUIRED->SELECT THE LOCATION->CHOOSE ANY FILTER AS REQUIRED (MIN OF ONE FILTER MUST BE SELECTED TO RUN THE REPORT)-> SELECT THE DATA ON THE RIGHT SIDE & CHOOSE THE NEXT FILTER AS REQUIRED->LIKEWISE EACH FILTER CAN BE SELECTED AND DRILLED DOWN AS REQUIRED-> ALL THE SELECTIONS MADE CAN BE CONVERTED INTO REPORT BY CLICKING ON THE REPORT OPTION IN THE TOP-> BOX WILL APPEAR-> NOW CLICK ON THE COLUMN GROUP DROPDOWN & SELECT THE FIELD WHICH YOU REQUIRE TO BE PLACED IN THE COLUMN SIDE OF THE REPORT-> SELECT THE ATTRIBUTES BELOW LIKE THE PRODUCT , BRAND ETC AS REQUIRED-> CLICK VIEW TO VIEW THE REPORT->YOU CAN ALSO SAVE THE REPORT BU GIVING A TITLE TO IT IN THE TITLE COLUMN & CLICK THE SAVE BUTTON BELOW->CLICK EXCEL TO DOWNLOAD THE REPORT IN EXCEL

Sale Comparer

GO TO ANALYTICAL->SELECT SALES COMPARER->SELECT THE FIRST DATE RANGE AS REQUIRED->SELECT THE SECOND DATE RANGE AS REQUIRED FOR THE COMPARISION->SELECT THE LOCATION->CHOOSE ANY FILTER AS REQUIRED (MIN OF ONE FILTER MUST BE SELECTED TO RUN THE REPORT)-> SELECT THE DATA ON THE RIGHT SIDE & CHOOSE THE NEXT FILTER AS REQUIRED->LIKEWISE EACH FILTER CAN BE SELECTED AND DRILLED DOWN AS REQUIRED->ON THE REPORT SIDE TWO COMPARISION AS PER THE DATE SELECTED WILL BE VIEWED-> CLICK EXCEL TO DOWNLOAD THE REPORT IN EXCEL

Sales Vs Purchase

GO TO ANALYTICAL->SELECT SALES VS PURCHASE->SELECT THE PURCHASE DATE RANGE AS REQUIRED ->SELECT THE SALE DATE RANGE AS REQUIRED FOR THE COMPARISION->SELECT THE LOCATION->CHOOSE ANY FILTER AS REQUIRED (MIN OF ONE FILTER MUST BE SELECTED TO RUN THE REPORT)-> SELECT THE DATA ON THE RIGHT SIDE & CHOOSE THE NEXT FILTER AS REQUIRED->LIKEWISE EACH FILTER CAN BE SELECTED AND DRILLED DOWN AS REQUIRED->ON THE REPORT SIDE TWO DATAS AS PER THE DATE SELECTED WILL BE VIEWED-> CLICK EXCEL TO DOWNLOAD THE REPORT IN EXCEL

Report Builder

GO TO ANALYTICAL->SELECT REPORT BUILDER->SELECT THE SOURCE AS REQUIRED TO GENERATE THE REPORT->TICK THE FILTERS FROM THE ATTRIBUTES,FIELDS & AGGREGATORS AS REQUIRED->CLICK SEARCH TO LOAD THE REPORT->APPLY THE CONDITION OPTION BELOW IF YOU TO FILTER THE ATTRIBUTES AT THEIR INDIVIDUAL LEVEL->ADD THE SAME -> THEN CLICK SEARCH TO GENERATE THE REPORT-> CLICK EXCEL TO DOWNLOAD THE REPORT IN EXCEL -> PIVOT OPTION CAN BE USED TO CONVERT THE REPORT IN PIVOT FORMAT->CLICK SAVE TO SAVE THE REPORT AS PER YOUR CHOICE, LATER THE SAME CAN BE LOADED WITH THE SAVED REPORT SELECTION

Purchase planner

GO TO ANALYTICAL->SELECT PURCHASE PLANNER->SELECT THE SOURCE AS REQUIRED TO GENERATE THE REPORT->TICK THE FILTERS FROM THE ATTRIBUTES,FIELDS & AGGREGATORS AS REQUIRED->CLICK SEARCH TO LOAD THE REPORT->APPLY THE CONDITION OPTION BELOW IF YOU TO FILTER THE ATTRIBUTES AT THEIR INDIVIDUAL LEVEL->ADD THE SAME -> THEN CLICK SEARCH TO GENERATE THE REPORT-> CLICK EXCEL TO DOWNLOAD THE REPORT IN EXCEL -> PIVOT OPTION CAN BE USED TO CONVERT THE REPORT IN PIVOT FORMAT->CLICK SAVE TO SAVE THE REPORT AS PER YOUR CHOICE, LATER THE SAME CAN BE LOADED WITH THE SAVED REPORT SELECTION