Question: how to make fdt in excel?
Answer: First, insert a pivot table. ... , Click any cell inside the Sum of Amount column. ... , Choose Count and click OK., Next, click any cell inside the column with Row Labels. ... , Enter 1 for Starting at, 10000 for Ending at, and 1000 for By. ... , Result:, To easily compare these numbers, create a pivot chart.